How to Check Group of OSDBA
OSDBA or OSOPER OSDBA and OSOPER are just a symbol name defined by Oracle database, users belonged to either group are natively granted to use… Read More »How to Check Group of OSDBA
SYSOPER
How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
ORA-28009 Tried to connect to a database, but it failed with ORA-28009. SQL> conn sys/password@orclpdb ERROR: ORA-28009: connection as SYS should be as SYSDBA or… Read More »How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
SYSDBA vs SYSOPER Privileges
SYSDBA vs SYSOPER According to Oracle documentation about administrative accounts and privileges, I compared their privileges between SYSDBA and SYSOPER as below: Allowed Actions SYSDBA… Read More »SYSDBA vs SYSOPER Privileges
Who has SYSDBA Privilege?
SYSDBA Privilege SYSDBA is a system privilege. By default, only SYS has the privilege, but it can be changed by granting to other user. Although… Read More »Who has SYSDBA Privilege?