Data Dictionary table name required ..

[gotcha1210]

Hi ..

I would like to get the name of the Data dictionary table which holds the grants like connect / resource to a particular user.
Just after a user is created, these grants are applied for the new user to work on oracle.
Any idea which data dict table I would have to query.

Thanks in adv for any reply ..

[gandolf989]

Like this?

SQL> SELECT * FROM dict WHERE table_name LIKE '%SYS%PRIV%';

TABLE_NAME                     COMMENTS
------------------------------ ------------------------------------------------------------
USER_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager for the user
USER_SYS_PRIVS                 System privileges granted to current user
ROLE_SYS_PRIVS                 System privileges granted to roles

Elapsed: 00:00:00.94
SQL> 

LIDXPNN - t31a=> SELECT * FROM dict WHERE table_name LIKE '%ROLE%';

TABLE_NAME                     COMMENTS
------------------------------ --------------------------------------------
USER_ROLE_PRIVS                Roles granted to current user
ROLE_ROLE_PRIVS                Roles which are granted to roles
ROLE_SYS_PRIVS                 System privileges granted to roles
ROLE_TAB_PRIVS                 Table privileges granted to roles
SESSION_ROLES                  Roles which the user currently has enabled.
10 rows selected.

Elapsed: 00:00:00.71

[gotcha1210]

Thanks ..
That was fast ...