| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Role not found in ROLE_SYS_PRIVS and ROLE_TAB_PRIVS
Replace
role_sys_privs -> dba_sys_privs
role_tab_privs -> dba_tab_privs
and you see what you expected.
To create a user A similar to user B, everything is in:
dba_sys_privs dba_role_privs dba_tab_privs dba_users dba_ts_quotas
Don't forget to recurse dba_role_privs (hierarchical SQL query with
"connect by"), to get roles granted to roles, if you desire to
"explore" the roles.
Received on Wed Oct 18 2006 - 14:27:05 CDT
 |
 |