BDF
You can grant administrative privileges, such as SYSOPER and SYSBACKUP, to schema-only (passwordless) accounts. (B correct)
-Privilege analysis is now available as part of Oracle Database Enterprise Edition. (D correct)
-The unified auditing top-level statements feature enables you to audit top-level user (direct user) activities in the database without collecting indirect user activity audit data. (F correct)
https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html
alter user c##test_sysdba no authentication
Error report -
ORA-40367: An Administrative user cannot be altered to have no authentication
type.
40367. 00000 - "An Administrative user cannot be altered to have no authentication type."
*Cause: An attempt was made to alter an administrative user to have no
authentication type.
*Action: Revoke administrative privilege from the user
before attempting to alter the user.
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.
veginha
Highly Voted 4 years agomarcinb32
4 years agoacesonly
Most Recent 1 month, 3 weeks agoantonica
3 months, 2 weeks agoacesonly
1 month, 3 weeks agoantonica
3 months, 2 weeks ago_gio_
1 year agoNeil107
2 years, 11 months agojanw
3 years, 10 months ago