File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 3753

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!