In one of your databases, user KING is: 1. Not a DBA user 2. An operating system (OS) user Examine this command and its output: What must you do so that KING is authenticated by the OS when connecting to the database instance?
A.
Set OS_AUTHENT_PREFIX to OPS$
B.
Have the OS administrator add KING to the OSDBA group
A - false; in that case both db user and OS user must have name OPS$KING
B - false; it would grant DB user DBA role, but login would not succeeded because the user is not identified externally
C - false; user KING is not in DBA group
D - false; REMOTE_LOGIN_PASSWORDFILE must be used to enable user login
E - true; when user is IDENTIFIED EXTERNALLY, it can login with OS authentication
Correct Answer is D, REMOTE_LOGIN_PASSWORDFILE=NONE Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system.
REMOTE_LOGIN_PASSWORDFILE: NONE
NONE: Instructs the Oracle system not to use password files, and the login of privileged users is authenticated by the operating system.
NONE Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system.
NONE
Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system.
https://docs.oracle.com/cd/B14117_01/server.101/b10755/initparams176.htm
https://titanwolf.org/Network/Articles/Article?AID=cf58b9e3-cc76-4fe0-b7c2-3073595bc869
E is the correct one:
https://docs.oracle.com/cd/B19306_01/network.102/b14266/admnauth.htm#i1006459
Creating a User Who Is Authenticated Externally
The following statement creates a user who is identified by Oracle and authenticated by the operating system or a network service. This example assumes that OS_AUTHENT_PREFIX = "".
CREATE USER scott IDENTIFIED EXTERNALLY;
Using CREATE USER ... IDENTIFIED EXTERNALLY, you create database accounts that must be authenticated by the operating system or network service. Oracle will then rely on this external login authentication when it provides that specific operating system user with access to the database resources of a specific user.
But King is NOT a DBA user, as per stated in the question, and I assume is a requirement to leave that unchanged. So you don't allow a user the DBA role (even worse actually, it would SYSDBA) just for it to be able to connect to the database.
E is the most correct if you want to allow the user to be authenticated by OS without changing its role.
I think answer should be A.
Because unless you set OS_AUTHENT_PREFIX you can't have this user created on database which can identified externally.
And when you have OS_AUTHENT_PREFIX set to OPS$ (eg) , you need to alter OPS$KING to identified externally not to KING.
A - ist wrong
a prefix can be empty, it is not necessary to set it back to default OPS$
upvoted 5 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sharif1
Highly Voted 3 years, 5 months agoama
3 years, 5 months agoMuhab
Highly Voted 3 years, 5 months agoSchmeili
3 years, 4 months agoSimoneF
3 years agonautil2
Most Recent 2 months, 3 weeks agoOracle2020
5 months agoauwia
6 months, 1 week agoGuhborges
1 year, 11 months agoryuah
2 years agosaadkhan45
2 years, 1 month agosaadkhan45
2 years, 1 month agoofranco
2 years, 3 months agoeddkzew
3 years agoEkos
3 years, 2 months agoSimoneF
3 years agomberrios
3 years, 2 months agoavanand
3 years, 4 months agoNowOrNever
3 years, 3 months ago