Database Administration (MOSC)

MOSC Banner

A user can administer the privileges of some schemas only?

edited Sep 8, 2016 9:35AM in Database Administration (MOSC) 5 commentsAnswered

My coworkers are developing an application and they want to create a "manager" user, and three different users with objects of its own, let's say commercial, financial and tech.

They want the manager user be able to create app users (which would be DB users as well) and grant read and write privileges to them on the other three users' objects. They don't want to issue the grant command "with grant option" individually for each one of the three users objects to the manager for he can transfer them to the new app users, they are looking for an easier and quick alternative.

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