Database Security Products (MOSC)

MOSC Banner

grant privilege to user

edited May 6, 2015 10:02AM in Database Security Products (MOSC) 5 commentsAnswered

Currently I have problem with our database has objects in one schema is automatically created daily.

and There is user request to create user for select object for that.

We do not want to grant SELECT ANY TABLE privilege to that user, because it seems not secure then will have

privilege to select and see other object of other schema.

Thus, what should the privilege I can grant to that use to see only object of one schema which it auto create daily like this.

Thanks and Regards,

Vorleak

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