is there any System Privilege like 'select all on schema'
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
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
0