-
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
Raghu
-
Some more info :
I need USER, GRANTEE, ROLE, PRIVILIGES for all the users.
-
-
Thanks. But this is not really helping. I couldn't find anything which provides USERS and their ROLES.
-
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|