SyntaxFix
Write A Post
Hire A Developer
Questions
Tags
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...
This question is related to oracle oracle11g
oracle
oracle11g
You need only to write:
GRANT DBA TO NewDBA;
Because this already makes the user a DB Administrator
Source: Stackoverflow.com