Question

which of the following sequences of statements would ensure that jennifer has the privileges of the roles of finance and executive? create role executive inherit; create role finance inherit; grant finance to jennifer; grant executive to jennifer; create role executive noinherit; create role finance noinherit; grant finance to jennifer; grant executive to finance; create role executive noinherit; create role finance noinherit; grant executive to jennifer; grant executive to finance; create role executive noinherit; create role finance inherit; grant finance to jennifer; grant executive to finance;

Answer 1

To give Jennifer the privileges of the 'finance' and 'executive' roles, create the roles with the 'inherit' property and then grant both roles to Jennifer directly.

Step-by-step explanation:

To ensure that Jennifer has the privileges of both the finance and executive roles, you need to choose a sequence of statements that correctly assigns these roles and their privileges. Given the options, the one that achieves this is:

• Create role executive inherit;
• Create role finance inherit;
• Grant finance to Jennifer;
• Grant executive to Jennifer;

With these commands, Jennifer will directly inherit the privileges from both roles because the roles are created with the inherit property. If the roles were created with the noinherit property, Jennifer would only acquire the privileges if she SET ROLE to the specific role.