Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)
Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)
Users with the SYSBACKUP privilege can view data from any data dictionary view or dynamic performance view. They cannot create restore points and they cannot drop tablespaces. This specialized privilege focuses solely on backup and recovery tasks without extending to general data manipulation or user management operations.
ADE correct https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and-role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7
I think ACD is correct
Additional also E
I have to correct myself: I agree with ADE too.
agree with ADE. https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and-role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7
Two answers are right, E is not correct because you can't drop all tablespace (system for example can't be drop)
any tablespace? can drop system tablespace? the question is no enough to precise
Agree with ADE
Agree with ADE. But when I create user with SYSBACKUP privilege. I cannot create table or drop tablespace. it's wierd.
Because you miss AS SYSBACKUP on connection (sqlplus user as sysbackup)
ADE, tested
ADE is the correct answer. Please check below https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dbseg/configuring-privilege-and-role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7
ADE - correct answer. Verified
ADE is correct