- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Copy Database User to create new users/ assign privileges similar to another user
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.
Create a role with all the privileges that a user will need and you can assign that role to different users. Vote down.