SyntaxFix

[oracle] Granting DBA privileges to user in Oracle

You need only to write:

GRANT DBA TO NewDBA;

Because this already makes the user a DB Administrator

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to oracle11g

• Convert timestamp to date in Oracle SQL • Query to display all tablespaces in a database and datafiles • Oracle Installer:[INS-13001] Environment does not meet minimum requirements • Forgot Oracle username and password, how to retrieve? • Extract number from string with Oracle function • How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1 • Add days Oracle SQL • How to determine tables size in Oracle • ORA-28000: the account is locked error getting frequently • Oracle listener not running and won't start