Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 59

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

    Correct Answer: B

    When a user creates a role, they do not automatically become the owner of that role. Instead, the ownership of the role is initially assigned to the role that was used to create it. To become the owner of the role, specific commands such as GRANT OWNERSHIP must be executed. Thus, it is false that the user maintains ownership until it is transferred to another user.

Discussion
SV1122Option: B

By default, a newly-created role is not assigned to any user, nor granted to any other role. https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

Badenhop

The question is regarding the assignment of ownership, not the assignment of the role. B is still correct though since the role is not initially owned by the user but rather by the role the user used during creation.

SurbinOption: B

Ownership is associated with role and not with users .

pranaligOption: B

Correct answer:B ownership cannot be transfered

ColourseunOption: B

The answer is False. When a user creates a role, they are initially assigned the CREATE_ROLE privilege on the role. However, they do not automatically become the owner of the role. The ownership of the role is initially set to the SYSADMIN role. To become the owner of the role, the user must use the GRANT OWNERSHIP command. Once the user has become the owner of the role, they can manage the role and grant and revoke privileges on the role to other users. Therefore, the correct answer is False.

umidjon03

a user cannot be owner of a object. When a role creates another role, the role will be owner of which it created. Answer is False, but I lil bit confused with your definition

niho1993Option: A

The statement is true: When a user creates a role, they are initially assigned ownership of the role, and they maintain ownership until it is transferred to another user. In many role-based access control systems or permission management systems, the user who creates a role is automatically designated as the owner of that role, and they have the authority to manage and modify the role's permissions and settings.

J0nT3rraOption: B

Seems like a tricky-wording question :/ Users don't own nothin

sidyndiayeOption: A

A. is the correct answer

KarBiswaOption: B

Snowflake does not follow user based access control like oracle

Percy2112Option: B

False. Ownership transfer from role to role.

Marge23Option: B

false once a role is created it has no function unless assigned or granted.

Mayuri917233Option: A

A is the answer.

SushY18Option: A

To own an object means that a role has the OWNERSHIP privilege on the object. Each securable object is owned by a single role, which by default is the role used to create the object. When this role is assigned to users, they effectively have shared control over the object. In a regular schema, the owner role has all privileges on the object by default, including the ability to grant or revoke privileges on the object to other roles. In addition, ownership can be transferred from one role to another. However, in a managed access schema, 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.

Tapasgup007Option: B

B is correct

bharathmvOption: B

OPtion B is correct

kjdfsafc87456Option: B

Custom roles (i.e. any roles other than the system-defined roles) can be created by the USERADMIN role (or a higher role) as well as by any role to which the CREATE ROLE privilege has been granted. By default, a newly-created role is not assigned to any user, nor granted to any other role.

kapsdangs001Option: A

make sense

vivek_nitdOption: B

Answer: B Ownership is associated with role which creates the custom role.