Database Administration (MOSC)

MOSC Banner

need clarifications on privs

edited Apr 4, 2012 6:17PM in Database Administration (MOSC) 2 commentsAnswered
Hi,

I have schema A and schema B,i have granted access to schema A on all objects of schema B with grant option ,now if i create any new object on schema B i need to grant access again to schema A,is there anyother way apart from 'grant select any objects' access  to dynamically grant access to schema A for all newly created objects of schema B.

Thanks

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