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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Post Details

Added on Jan 22 2016
2 comments
3,489 views