Multiple choice technology databases

If an User is Identified by OS, he can connect to the database with SQLPLUS -S / as SYSDBA

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The statement is false. Even if a user is IDENTIFIED EXTERNALLY (OS authentication), they cannot connect with 'sqlplus -S / as SYSDBA' without being explicitly granted SYSDBA privileges. The '/' syntax allows OS-authenticated users to connect, but only if they have a corresponding database account with appropriate privileges. A user identified externally still needs proper SYSDBA grant to use 'as SYSDBA'. Without this grant, the connection attempt will fail regardless of OS authentication.

Keep practicing — related questions