This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes An Oracle DBA question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "An Oracle DBA question" Watch "An Oracle DBA question" New topic

An Oracle DBA question

Jane Somerfield
Ranch Hand

Joined: Jul 20, 2002
Posts: 193
I'm using Oracle 10g.

I logged into the DB as "sysdba" using sqlplus and created a role "MY_ROLE":

SQL> create role MY_ROLE;

I granted some privileges on MY_TABLE to MY_ROLE as below:

SQL> grant select, insert, update, delete on MY_TABLE to MY_ROLE;

I can see MY_ROLE with

SQL> select name from user$ where type#=0 and name like 'MY_%';

My question is in which Oracle table where I can review the
MY_ROLE's privileges that I granted.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749

I don't know the exact table name, but you should either search google for "Oracle meta data tables" or just use a graphical viewer to see the full list of system tables in the database. I believe the user tables start with "user_"

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: An Oracle DBA question
It's not a secret anymore!