The database instance has the following parameter setting: OS_AUTHENT_PREFIX =
OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES =
FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You
create a database user OPS$SKD, and then assign external authentication. The user
OPS$SKD has the CREATE SESSION privilege. What would you achieve by the above
process?
A.
The authentication detail for the database user OPS$SKD is recorded in the password
file.
B.
The local operating system user SKD will be able to access the database instance
without specifying the username and password.
C.
The database user OPS$SKD will be able to administer the database.
D.
The database user OPS$SKD has to login with the password of the local operating
system user SKD to access the database instance.
The answer is:
B.
The local operating system user SKD will be able to access the database instance
without specifying the username and password.