True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
When you create a custom role, it is not necessarily a best practice to immediately grant that role to the ACCOUNTADMIN. Instead, it is generally recommended to create a hierarchy of roles where custom roles are granted to the SYSADMIN role, which is already managed by the ACCOUNTADMIN role. This practice aligns with ensuring proper role hierarchy and management within the system, maintaining security and operational efficiency.
100% false. SYSADMIN should immediately be granted the role, then ACCOUNTADMIN will automatically have the grant through SYSADMIN.
https://docs.snowflake.com/en/user-guide/security-access-control-overview#roles "When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN." B is correct according to that article
https://docs.snowflake.com/en/user-guide/security-access-control-considerations Important: By default, not even the ACCOUNTADMIN role can modify or drop objects created by a custom role. The custom role must be granted to the ACCOUNTADMIN role directly or, preferably, to another role in a hierarchy with the SYSADMIN role as the parent. The SYSADMIN role is managed by the ACCOUNTADMIN role.
correct A
keyword in the question is "immediately" and that makes the correct answer as False. Granting custom role to ACCOUNTADMIN is not the only option. It can be assigned to role hierarchy with SYSADMIN as parent also
We don't have to granted the role to Accountadmin Its automatically have throught the SysADMIN role
The custom role must be granted to the ACCOUNTADMIN role directly or, preferably, to another role in a hierarchy with the SYSADMIN role as the parent.
B is correct
FALSE, Should be assigned to SYSADMIN role
B.False
B. False
True ans A Important By default, not even the ACCOUNTADMIN role can modify or drop objects created by a custom role. The custom role must be granted to the ACCOUNTADMIN role directly or, preferably, to another role in a hierarchy with the SYSADMIN role as the parent. The SYSADMIN role is managed by the ACCOUNTADMIN role.
Best practice is to assign it to ACCOUNTADMIN;
By default, not even the ACCOUNTADMIN role can modify or drop objects created by a custom role. The custom role must be granted to the ACCOUNTADMIN role directly or, preferably, to another role in a hierarchy with the SYSADMIN role as the parent. The SYSADMIN role is managed by the ACCOUNTADMIN role. https://docs.snowflake.com/en/user-guide/security-access-control-considerations#managing-custom-roles Even it is mentioned preferably SYSADMIN, the idea is to grant custom role to ACCOUNTADMIN.
According to the docs: Accountadmin. https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html#managing-custom-roles
Sorry, should be B: False. It states "preferably, to another role in a hierarchy with the SYSADMIN role as the parent.". Can't remove my previous comment and vote ...
The best practice is to assign it to SYSADMIN role, B is correct
It is TRUE.
It is TRUE