NERO LARP :: Forums :: Main Category :: General Discussion
 
<< Previous thread | Next thread >>
Find procedure and packages which using select any table and select any dictionary
Moderators: KenGillis, KatieMueller, AdamTaylor, jvalenti, Clint, NickDenny, ShellyHollon, KnightofEvendarr, jasonmote, JSchneider, fdhogan, DDS, jvalentinero, BrianCook, dcashel
Author Post
RyanCaleb
Wed Dec 06 2017, 10:03AM
Registered Member #68204
Joined: Tue Sep 12 2017, 12:02PM
Posts: 87
Hi,

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.

How to check anyone using select any table ,select any dictionary privileges in the schema?


Please help.
Thanks!

I didn't find the right solution from the Internet.

References:https://community.oracle.com/thread/4103439

storytelling video
Back to top
 

Jump:     Back to top

Syndicate this thread: rss 0.92 Syndicate this thread: rss 2.0 Syndicate this thread: RDF
Powered by e107 Forum System