Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

blkrishnaraoJan 22 2016

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.

Comments

Processing

Post Details

Added on Jan 22 2016
2 comments
3,519 views