User's Roles and Privileges

Can someone help with a query which can provide all users and their access information like USER, ROLE, GRANTEE information.

Thanks In Advance

select * from DBA_ROLE_PRIVS ,, If not enough

Have to join with DBA_ROLES and DBA_USERS

Some more info :
I need USER, GRANTEE, ROLE, PRIVILIGES for all the users.

There are TONS of scripts on metalink. Search for yourself.


http://metalink.oracle.com/metalink/...T&id=1019486.6

http://metalink.oracle.com/metalink/...T&id=1020086.6

http://metalink.oracle.com/metalink/...T&id=1020176.6

http://metalink.oracle.com/metalink/...T&id=1050267.6

Thanks. But this is not really helping. I couldn't find anything which provides USERS and their ROLES.

Quote:

---

Originally posted by harrygulls
Thanks. But this is not really helping. I couldn't find anything which provides USERS and their ROLES.

---

SELECT GRANTED_ROLE, GRANTEE FROM DBA_ROLE_PRIVS

Quote:

---

Originally posted by harrygulls
Thanks. But this is not really helping. I couldn't find anything which provides USERS and their ROLES.

---

It's all there. You need to help yourself and modify them appropriately.