Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding all grants to a particular user
Thanks, I've already solved the problem. I wanted to see everything, i.e. as per my original question "require EXACTLY duplicating". I had a problem where a particular user was having problems. I think it's network related though. The SQL I included should do what I want. It looks like I was...- Aerobatty
- Post #6
- Forum: Oracle: All versions
-
Finding all grants to a particular user
I have searched the archives and found something very close to the answer I was after in thread759-1205523 . I have added a hierarchical lookup to allow returning the privileges of all nested roles a user belongs to. SELECT grantee, 'Explicit System Privilege', null object_name, privilege...- Aerobatty
- Post #5
- Forum: Oracle: All versions
-
Finding all grants to a particular user
I have an issue that will require exactly duplicating an oracle users grants. Is it possible to view a users entire set of grants to all objects by a single SQL??- Aerobatty
- Thread
- Replies: 6
- Forum: Oracle: All versions
