Forum Stats

  • 3,874,709 Users
  • 2,266,767 Discussions
  • 7,911,957 Comments

Discussions

Copy Database User to create new users/ assign privileges similar to another user

blkrishnarao
blkrishnarao Member Posts: 24
edited Jan 22, 2016 2:00PM in Database Ideas - Ideas

Its very common that a simple task as creating new user or assigning roles to a user comes in as a bundle, where most commonly people ask for roles/user with privileges similar to another user.

If Oracle can provide a feature to copy a complete user blanket (privileges/roles).

Create user User_new as old_user;

Create user User_new as Old_user copy all privileges;

Where User_new can be a set of Users separated by a comma.

Although its not tough to create a script for it and get it done, but a permanent feature could be helpful.

top.gunBPeaslandDBA
4 votes

Active · Last Updated

Comments