Data Dictionary table name required ..

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 ..

Like this?

Code:

---

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

---

Thanks ..
That was fast ...