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!

Find procedure and packages which using select any table and select any dictionary

N_RajDec 5 2017 — edited Dec 5 2017

Hi All,

We have Oracle 11.2.0.4 on Aix 7.

I am asked to review the oracle system privileges to remove unnecessary privilege on NON PROD DB.One of the dba member gave any privileges to the schema.

We have the schema scott which has connect,resource roles and select any table ,select any dictionary and debug any procedure privileges.

The scott schema has tables, procedure and packages also.

1,How to check anyone using select any table ,select any dictionary privileges in the schema. I guess,by auditing

2,How to check anyone using select any table ,select any dictionary privileges in the procedure and packages for the schema.

3.How to find system privilege without role ( ie directly system privilege assigned to the users without role )

I knew that it is very difficult one to find it.

Any suggestions.

Thanks & Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2018

Added on Dec 5 2017

#general-database-discussions

4 comments

276 views