Hi learn,
The best you can probably do is to query the dba_sys_privs and dba_role_privs views and select the roles and or privileges you want to grant to your users.
Than create a role which holds all the privileges you want to grant to your users.
Then grant this role to your users.
HTH
tycho




Reply With Quote