Home > IT Answers > Oracle > Query SYSTEM tablespace Privileges
Ragheed
0 pts.
 Query SYSTEM tablespace Privileges
Oracle, SYSTEM TABLESPACE
I am trying to figure out what privileges two users have to the SYSTEM tablespace... However quering the "user_sys_pivs" table will only give me the privs of the user I am logged onto the system with. Is there anyway I can find out that information without logging to their account. I am using orcl 8i and oracle 9i

Software/Hardware used:
ASKED: October 29, 2007  9:15 AM
UPDATED: October 29, 2007  3:13 PM
RELATED QUESTIONS
Answer Wiki:
use all_sys_privs.
Last Wiki Answer Submitted:  October 29, 2007  3:13 pm  by  Tudz Drkl   0 pts.
All Answer Wiki Contributors:  Tudz Drkl   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _