What is a best practice after creating a custom role?

The correct answer is B. Assign the custom role to the SYSADMIN role. Assigning the custom role to the SYSADMIN role is considered a best practice because it allows the SYSADMIN role to manage objects created by the custom role. This is important for maintaining proper access control and ensuring that the SYSADMIN can perform necessary…

Account Access and Security

Question

Options

ACreate the custom role using the SYSADMIN role.
BAssign the custom role to the SYSADMIN role
CAssign the custom role to the PUBLIC role
DAdd__CUSTOM to all custom role names

How the community answered

(19 responses)

A
5% (1)
B
89% (17)
D
5% (1)

Explanation

Assigning the custom role to the SYSADMIN role is considered a best practice because it allows the SYSADMIN role to manage objects created by the custom role. This is important for maintaining proper access control and ensuring that the SYSADMIN can perform necessary administrative tasks on objects created by users with the custom role.

Topics

#Role-Based Access Control#Security Best Practices#Snowflake Roles#Role Hierarchy

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice