Hi,
Although sys user is most priviliged user in Oracle database but also you can get ORA-01031: insufficient privileges SYSDBA.
If this error is not related with the Oracle database vault, then read the following post to grant priviliges to related user.
How to Grant and Revoke Privileges | Create and Drop any User in Oracle Database
You can get ORA-01031: insufficient privileges error event though you use sys user if Oracle Database Vault is open like following.
SQL> create user dd identified by dew; ORA-01031: insufficient privileges SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault'; PARAMETER ---------------------------------------------------------------- VALUE ---------------------------------------------------------------- Oracle Database Vault TRUE
To solve this problem you should close database and disable Oracle Database Vault option like following.
SQL> shutdown immediate $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk dv_off ioracle
SQL> startup ORACLE instance started. Total System Global Area 2087780352 bytes Fixed Size 2221208 bytes Variable Size 1577061224 bytes Database Buffers 503316480 bytes Redo Buffers 5181440 bytes Database mounted. Database opened.
After database opened, we can create user like following.
SQL> create user mehmet identified by salih; User created. SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault'; PARAMETER ---------------------------------------------------------------- VALUE ---------------------------------------------------------------- Oracle Database Vault FALSE
If this error is not related with the Oracle database vault, then read the following post to grant priviliges to related user.
How to Grant and Revoke Privileges | Create and Drop any User in Oracle Database
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/