Database Administration (MOSC)

MOSC Banner

Which rigths to be able to create objetcs for others users, BUT not for myself.

edited Jan 12, 2014 11:51PM in Database Administration (MOSC) 5 commentsAnswered ✓
hi,I know, the subject of this post is difficult to understand ...

what I want to do is : creating a user who can create objects (tables, indexes, ...) for other users, BUT who can't create objects for himself.

In other words, I want to create an operator user like this:

  connect Operator/xxxx
  create table user1.TEST (.....) : OK
  create table TEST2 : KO

  Is it possible ?

  thank's


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