This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 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