- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Copy Database User to create new users/ assign privileges similar to another user
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.