In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).

The correct answer is B. Users with the SECURITYADMIN role or higher, can grant object privileges in a managed access D. Users who are schema owners can grant object privileges in a managed access schema. In a managed access schema, the privilege management is centralized with the schema owner, who has the authority to grant object privileges within the schema. Additionally, the SECURITYADMIN role has the capability to manage object grants globally, which includes within managed…

Accounts and Security

Question

Options

AUsers with the SYSADMIN role can grant object privileges in a managed access schema.
BUsers with the SECURITYADMIN role or higher, can grant object privileges in a managed access
CUsers who are database owners can grant object privileges in a managed access schema.
DUsers who are schema owners can grant object privileges in a managed access schema.
EUsers who are object owners can grant object privileges in a managed access schema.

How the community answered

(53 responses)

A
2% (1)
B
87% (46)
C
8% (4)
E
4% (2)

Explanation

In a managed access schema, the privilege management is centralized with the schema owner, who has the authority to grant object privileges within the schema. Additionally, the SECURITYADMIN role has the capability to manage object grants globally, which includes within managed access schemas. Other roles, such as SYSADMIN or database owners, do not inherently have this privilege unless explicitly granted.

Topics

#Managed Access Schemas#Role-Based Access Control (RBAC)#Privilege Management#Security Roles

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice