Oracle
1Z0-074 · Question #4
USER1 is an OS user with the password oracle and is only a member of the oinstall group. In the ORCL database, the OS_AUTHEN_PREFIX value is ops$. Examine these commands executed by the DBA: SQL>…
The correct answer is C. Grant SYSRAC to ops$user1. Explanation/Reference:
Controlling User Access
Question
USER1 is an OS user with the password oracle and is only a member of the oinstall group. In the ORCL database, the OS_AUTHEN_PREFIX value is ops$. Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally; SQL> GRANT create session TO ops$user1; How can USER1 be given the SYSRAC privilege?
Options
- AMake User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in
- BGrant SYSRAC to user1.
- CGrant SYSRAC to ops$user1.
- DMake USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC
- EGrant SYSDBA to ops$user1
How the community answered
(30 responses)- B10% (3)
- C83% (25)
- D3% (1)
- E3% (1)
Explanation
Explanation/Reference:
Topics
#OS authentication#SYSRAC privilege#ops$ prefix#external authentication
Community Discussion
No community discussion yet for this question.