Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question about SELECT_CATALOG_ROLE

783956Aug 17 2010 — edited Aug 18 2010
Good afternoon,

Reading the Oracle 2 Day DBA document, there is a passage that states:

>
Nonadministrative users may also want to log in to
Database Control. For example, application developers may want to take advantage of
the Database Control interface to create or modify tables, indexes, views, and so on.
>

I granted SCOTT that role and proceeded to log in as SCOTT. (using Enterprise Manager)

I noticed that with this new role, SCOTT can look at the roles and privileges that other users have. Basically, SCOTT can look at a lot of stuff that he probably has no business looking at, much less knowing about.

The question is: am I being overly concerned or is this a role that should not be granted as lightly as the 2 Day DBA document implies ?

Thank you for your help,

John.

Edited by: 440bx - 11gR2 on Aug 17, 2010 4:06 PM - added the reference to Enterprise Manager.
This post has been answered by 618702 on Aug 17 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2010
Added on Aug 17 2010
9 comments
38,354 views