Re: how to dump user grants to a .sql file

Use dba_sys_privs for system privileges, dba_role_privs for roles and dba_tab_privs and dba_col_privs for object_privileges.

For example, for direct system privileges: select 'grant '||privilege||' to <your user> '||

       decode(admin_option, 'YES', 'with admin option;',';') from dba_sys_privs where grantee='<your user>';

...

--
Have a nice day
Michel

Marc Cluet <mcluet_at_worldonline.es> a écrit dans le message : 3858c659.9928756_at_news.worldonline.es...
> Hi
>
> Someone knows how to dump all the grants I've given to a specific user
> as SQL commands to a .sql file so I can execute it on another server
> to give the same permissions to the same user?
> Thank you!
> Marc
Received on Thu Dec 16 1999 - 06:55:31 CST