Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 958 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 958
Topic #: 1
[All SnowPro Core Questions]

Who can grant object privileges in a regular schema?

  • A. Object owner
  • B. Schema owner
  • C. Database owner
  • D. SYSADMIN
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
cybe001
6 months ago
A and B are correct A. Object owner: The owner of a specific object (such as a table, view, or procedure) within the schema has the authority to grant privileges on that object to other roles or users. Ownership of an object gives the user full control over it, including the ability to manage access. B. Schema owner: The owner of the schema has broader control and can grant privileges on any object within that schema. Schema owners typically have the ability to manage all aspects of the schema, including granting and revoking privileges for objects contained within it.
upvoted 1 times
...
CCC1234
8 months, 3 weeks ago
Selected Answer: A
https://docs.snowflake.com/en/user-guide/security-access-control-configure#label-managed-access-schemas Managed access schemas improve security by locking down privilege management on objects. In regular (i.e. non-managed) schemas, object owners (i.e. a role with the OWNERSHIP privilege on an object) can grant access on their objects to other roles, with the option to further grant those roles the ability to manage object grants. With managed access schemas, object owners lose the ability to make grant decisions. Only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant privileges on objects in the schema, including future grants, centralizing privilege management.
upvoted 2 times
...
0e504b5
9 months ago
Selected Answer: A
In regular (i.e. non-managed) schemas, object owners (i.e. a role with the OWNERSHIP privilege on an object) can grant access on their objects to other roles https://docs.snowflake.com/en/user-guide/security-access-control-configure#label-managed-access-schemas
upvoted 3 times
...
saffa
9 months ago
A beacause it's not managed schema
upvoted 3 times
...
tidz
10 months, 1 week ago
B. Only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the global MANAGE GRANTS privilege can grant privileges on objects in the schema.
upvoted 1 times
...
DR369
10 months, 2 weeks ago
Answer B
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...