Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be learning to Grant DBA Access to User in Oracle.
If we want to grant sysdba privilege to a user who is not a SYS user, the value of the “REMOTE_LOGIN_PASSWORDFILE” parameter in the spfile or pfile parameter file must be set to “exclusive”.
SQL SENTENCES
1 | SQL> GRANT SYSDBA TO ONUR; |
1 | # sqlplus <username>/<password>@<tns_alias> as sysdba |
1 | C:\Users\193475>sqlplus ONUR/onur@ONURDB as sysdba |
