Q: 4
Which two are true about granting privilege on objects?
Options
Discussion
I don't think B's right, since the WITH GRANT OPTION isn't restricted to just DBAs. A and C seem correct-owners always get all object privileges and need to grant REFERENCES for foreign keys. Pretty sure, but let me know if I missed a detail.
B tbh. WITH GRANT OPTION makes me think only DBAs can technically use that, since it's high privilege. Not sure I'm remembering this right though, maybe missing a detail about object owners granting too. Happy to be corrected if I'm off.
I'm not sure, but I'd pick D. I recall that only the owner can grant object privileges, so DBA users shouldn't be able to unless they're also the owner. Someone correct me if I'm missing an exception here, but that's how I remember it.
A and C imo, D is a common trap since DBAs can grant with special rights too.
I don’t think D is right. A and C fit with what I saw in past exam reports. Table owners always get all privileges, and you really do need references granted to set up a foreign key. Pretty sure, but open to corrections.
A and C tbh
A and C here, saw a similar scenario in a mock. Owners get all privileges on their objects by default, and references privilege is needed for foreign keys. Not 100% sure if I'm missing a corner case but pretty confident.
Its A and C
I think D. I thought only owners can grant object privileges, unless I'm missing something from DBA permissions. Correct me if that's wrong.
Its A and C, but D can get tricky since DBAs with admin rights can grant object privileges too.
Be respectful. No spam.