Database Security Products (MOSC)

MOSC Banner

is there any System Privilege like 'select all on schema'

edited Aug 14, 2010 6:53AM in Database Security Products (MOSC) 6 commentsAnswered
 Hi,
We have a request from users to have select privilege on schema level (rather than on typical object level ).
i.e we will grant like 'grant select on scott to robert'

This will help them to have privilege on objects(under speific schema) which are re-created by batch jobs every day.

Is there any such privilege exists ?

PS : I know I can manage this feature by programming but they don't want such solution embedded in application.

Best Regards,
Anurag

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center