SOL-C01 Question #39: Real Exam Question with Answer & Explanation

Question

You have a role hierarchy where 'ROLE A' has been granted to 'ROLE B', and 'ROLE B" has been granted to User 'USER X' 'ROLE R has 'SELECT privilege on 'TABLE_I' and 'INSERT' privilege on 'TABLE 2'. Assume that 'USER_X' is currently using the 'ACCOUNTADMIN' role. Which of the following statements accurately describe the privileges available to 'USER X'? (Choose two)

Options

• A` USER_X' can SELECT from only when the active role is set to
• BUSER_X' can SELECT from ` TABLE _ 1 ` and INSERT into ` TABLE _ 2 only when the active role
• CUSER_X can SELECT from 'TABLE_I" and INSERT into 'TABLE_2 regardless of the active role.
• DUSER X' cannot SELECT from 'TABLE 1 ` or INSERT into STABLE_2 because the privileges are

Explanation

Option B: The privileges associated with ROLE_A' are inherited by , and then by 'USER_X' when ROLE_B' is activated. Thus, USER_X can select from table 1 and insert into table_2 when active role is Role B. Option E: Because Accountadmin can do almost anything, any user in a session with active role accountadmin can perform nearly any operation. Option A is incorrect because user must use role B to select from table 1. Option C is incorrect because to select/insert, user must use role B or ACCOUNTADMIN .Option D is incorrect because the role hierarchy allows privilege inheritance. The privileges granted to roles are accessible only when those roles are active, and USER_X can perform any account related task with

No community discussion yet for this question.