How to create a user which would be able to create other users ? [message #675410] |
Thu, 28 March 2019 01:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/fe90d5d6e4086a5b106fbcdc11fd31b8?s=64&d=mm&r=g) |
a100
Messages: 34 Registered: March 2019
|
Member |
|
|
Hello all,
I need to create a user (in both Oracle 11 and 12) which has enough privileges to run the following commands:
CREATE USER {} IDENTIFIED BY "{sth}" DEFAULT TABLESPACE users QUOTA unlimited ON users
GRANT CREATE SESSION TO {}
GRANT CREATE TABLE TO {}
GRANT CREATE VIEW TO {}
GRANT CREATE SEQUENCE TO {}
and delete it
How do I do that ?
[Updated on: Thu, 28 March 2019 01:16] Report message to a moderator
|
|
|
|
|
|
|
|
|