hi,

i need to extract user creation, profiles and roles from a oracle 8
database. does anyone have any SQL code which can help me achieve the
same. i do not want to use th exp/imp process.

thanks.

vasant

On 21.08.2011 10:15, vask wrote:
http://www.oracle.com/technetwork/de...iew/index.html
http://download.oracle.com/docs/cd/E...s.htm#BACJFIFF
http://download.oracle.com/otn_hoste...ewlet_swf.html

Cheers

robert

--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

On Aug 21, 4:15*am, vask <vasant.na... (AT) gmail (DOT) com> wrote:
You can use SQL to extract object grants, system privileges grants,
and grants to or of roles rather easily by querying the rdbms
dictionary views: dba_tab_privs, dba_sys_privs, and dba_role_privs.

Here is an article on the subject with working SQL to get object
grants.

How do I find out which users have the rights, or privileges, to
access a given object ? http://www.jlcomp.demon.co.uk/faq/privileges.html

HTH -- Mark D Powell --

Vas:

# i need to extract user creation, profiles and roles from a oracle 8
database. does anyone have any SQL code which can help me achieve the
same. i do not want to use th exp/imp process.

....

Well of course a tool like Toad peels stuff like that apart without
needing to know sql ... it isn't really hard to do it with sql but if
you are asking and don't want to research yourself ... maybe a GUI
tool is what you want.