Can an Object Owner grant object privileges in a regular schema?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Can an Object Owner grant object privileges in a regular schema?

Explanation:
Ownership of an object gives you control over who can access it, and in a regular schema the object owner can grant object-level privileges to other roles. This is how access is delegated without transferring ownership. For example, the table owner can grant SELECT on that table to a role, and if desired, add WITH GRANT OPTION so that the receiving role can in turn grant that privilege to others. This behavior is a characteristic of regular schemas, not restricted to managed-access schemas, so the statement is true.

Ownership of an object gives you control over who can access it, and in a regular schema the object owner can grant object-level privileges to other roles. This is how access is delegated without transferring ownership. For example, the table owner can grant SELECT on that table to a role, and if desired, add WITH GRANT OPTION so that the receiving role can in turn grant that privilege to others. This behavior is a characteristic of regular schemas, not restricted to managed-access schemas, so the statement is true.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy