Menu
How do I grant a user DBA rights in Oracle? I guess something like:
CREATE USER NewDBA
IDENTIFIED BY passwd;
GRANT DBA TO NewDBA WITH ADMIN OPTION;
Is it the right way, or...
784
DBA is the standard role that can be granted by an administrator to another administrator. It includes all system privileges and should only be granted to the most trusted and qualified of users. Assigning this role to a user enables the user to administer the database.
To drop a connected user, you must first terminate the user sessions using the SQL statement ALTER SYSTEM with the KILL SESSION clause. You can drop a user from a database using the DROP USER statement. To drop a user and all the user schema objects (if any), you must have the DROP USER system privilege.
Database-Specific Privileges To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name.
You need only to write:
GRANT DBA TO NewDBA;
Because this already makes the user a DB Administrator
169
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
