Oracle12cでsysdba権限の付与コマンド

2021年11月11日

環境
Oracle 12c
Windows Server 2012 R2

操作例
> sqlplus / as sysdba
1.sysdba 権限の付与

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SQL> GRANT SYSDBA TO LOGUSER;
SQL> GRANT SYSDBA TO LOGUSER;
SQL> GRANT SYSDBA TO LOGUSER;

2.sysdba権限を削除

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SQL> REVOKE SYSDBA FROM LOGUSER;
SQL> REVOKE SYSDBA FROM LOGUSER;
SQL> REVOKE SYSDBA FROM LOGUSER;

 

Oracle 12c

Posted by arkgame