Home » RDBMS Server » Security » How to create a user which would be able to create other users ? (Oracle 11,12)
How to create a user which would be able to create other users ? [message #675410] Thu, 28 March 2019 01:15 Go to previous message
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
DROP USER {} CASCADE
How do I do that ?

[Updated on: Thu, 28 March 2019 01:16]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to Unwrap Wrapped PL SQL (Functions, Procedures, Packages etc)
Next Topic: TDE multiple master encryption keys within single schema.
Goto Forum:
  


Current Time: Fri Jan 24 15:10:50 CST 2020