MENU
In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).
Suggested Answer: B, D
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
30 comments · newest first
LE
Lenna
11 months ago
Yup, A and B are the correct choices for sure!
MI
Milly
11 months ago
Object owners should have that power too, right?
EM
Emiko
11 months ago
Wait, can schema owners really do that? Sounds off.
BU
Buck
11 months ago
I thought SECURITYADMIN was the only one that mattered here.
MA
Mari
11 months ago
SYSADMIN can definitely grant privileges, that's a fact!
LA
Latonia
12 months ago
I’m a bit confused; I thought only database owners could manage object privileges, but now I'm not so sure.
CL
Clay
12 months ago
I practiced a similar question, and I feel like schema owners might have the ability to grant privileges too.
EV
Evangelina
12 months ago
I remember something about SECURITYADMIN being important for managing privileges, but I can't recall if it's the only one.
AR
Aretha
1 year ago
I think users with the SYSADMIN role can definitely grant privileges, but I'm not sure about the others.
MI
Micah
1 year ago
I feel pretty confident about this topic. In a managed access schema, the SYSADMIN role and schema owners can grant object privileges. I'll select those two options and move on to the next question.
DE
Denna
1 year ago
Ah, this is a tricky one. I remember learning about managed access schemas, but I'm having trouble recalling the specifics of which roles can manage object privileges. I'll have to guess and hope I get at least two correct.
TR
Tran
1 year ago
Okay, for this type of question, I need to focus on the key details about managed access schemas and the roles that can grant object privileges. I'll review my notes and try to narrow down the options.
IN
Ines
1 year ago
Hmm, I'm a bit unsure about this one. I know managed access schemas have specific rules around privilege management, but I can't quite remember the details. I'll have to think this through carefully.
JA
Janet
1 year ago
This question seems straightforward, I think I can handle it. Let me think through the characteristics of roles that can manage object privileges in a managed access schema.
AN
Annelle
2 years ago
I know the answer to this one! It's B and E, for sure. Gotta keep those SECURITYADMIN folks and object owners in check, am I right? *winks*
SH
Sharika
2 years ago
Wait, are we supposed to select two answers? I was just going to say E, but I guess I need to pick another. Hmm, maybe C and E? Database owners and object owners, that sounds about right.
AR
Arthur
2 years ago
This is an interesting question! I'm going to go with B and D. The SECURITYADMIN role and schema owners should have the ability to manage object privileges.
LA
Lashandra
2 years ago
It's important to have the right roles assigned for managing object privileges in a managed access schema.
MU
Muriel
2 years ago
Yes, that's correct. Schema owners also have the ability to grant object privileges in a managed access schema.
WI
Willodean
2 years ago
I agree with you, users with the SECURITYADMIN role or higher can definitely manage object privileges.
KA
Kayleigh
2 years ago
I'm not sure about C) Users who are database owners can grant object privileges in a managed access schema. Can someone explain why that might be true?
AN
Anisha
2 years ago
I agree with that, but I also believe B) Users with the SECURITYADMIN role or higher, can grant object privileges in a managed access schema.
LA
Lavonna
2 years ago
D and E are the correct answers here. Schema owners and object owners can grant object privileges in a managed access schema.
LA
Lavonda
2 years ago
Users who are object owners can grant object privileges in a managed access schema.
LE
Leonida
2 years ago
Users who are schema owners can grant object privileges in a managed access schema.
BA
Barbra
2 years ago
D and E are the correct answers here.
FR
Francesco
2 years ago
I think A) Users with the SYSADMIN role can grant object privileges in a managed access schema.
LO
Lorrie
2 years ago
I think the answer is B and E. Users with the SECURITYADMIN role or higher, and users who are object owners, can grant object privileges in a managed access schema.
HE
Helga
2 years ago
Yes, and users who are object owners can also grant object privileges in a managed access schema.
PA
Paulene
2 years ago
I agree, users with the SECURITYADMIN role or higher can grant object privileges in a managed access schema.