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

blkrishnarao

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.

William Robertson

This seems to be a duplicate of

Gbenga Ajakaye

Create a role with all the privileges that a user will need and you can assign that role to different users. Vote down.