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!

Normal user can access all Data Dictionary views

Girish AApr 6 2009 — edited Apr 8 2009

We have oracle 10g ( 10.2.0.2) on HPUX

I have created a user and granted role to a user with following commands

create user ABCD identified by XYZ$04022009 default tablespace tbs0356 temporary tablespace tmp098 quota unlimited on tbs0356 profile normal;

grant SELECT_ROLE to ABCD;

The role SELECT_ROLE has only - CREATE SESSION system privilege and all other are SELECT privileges on tables.

But when I logged in as user ABCD I can able to access all data dictionary views.

There are no ROLES granted to SELECT_ROLE.

I have checked the parameter O7_DICTIONARY_ACCESSIBILITY but it is set to FALSE.

Can anybody suggest me why it is happening?

Thanks & Regards
Girish

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2009

Added on Apr 6 2009

#general-database-discussions

20 comments

1,277 views