Re: Moving user to another instance... --- addition

Piotr Kolodziej wrote in message <6vgbac$971$1_at_sunrise.pg.gda.pl>... [cut]
>Yes, that's possible. Use sys.dba_users dictionary view to get
>all necesary information about user name, encrypted password
>(use 'identified by values' feature of create or alter user),
>tablespaces and profile and write a proper script.
>From sys.dba_role_privs and sys.dba_tab_privs (maybe sys.dba_col_privs)
>u may get all user grants.

...and from sys.dba_sys_privs get system privileges _explicitly_ granted to the users.

Piotr Kolodziej Received on Wed Oct 07 1998 - 14:23:23 CDT