Chapter 1 of 6 · Snowflake ADA-C02

Snowflake Security, RBAC, and User Administration

Administrative roles, RBAC design, grants, auditing, authentication, MFA, key pairs, OAuth, networks and SCIM.

  • 16topics
  • 1 h 10 minfast track
  • 6diagrams and exhibits
  • 31%of the exam

Topics in this chapter

Take them in order, or jump to the one you need.

  1. 1Administrative Roles - ORGADMIN, ACCOUNTADMIN and System Role HierarchyManage Snowflake administrative roles: ORGADMIN and ACCOUNTADMIN use cases, system role hierarchy, securing ACCOUNTADMIN and…Diagram5 min
  2. 2Access Control Frameworks - DAC, RBAC and UBAC and Designing the FrameworkCompare the Snowflake access control frameworks DAC, RBAC and UBAC and design an access control framework from business…4 min
  3. 3Custom Security Roles, Role Inheritance and Aligning Access to Business FunctionsCreate custom roles, understand how role inheritance affects grants and revokes, and align object access with business functions…4 min
  4. 4Object Privileges, Granting Through Inheritance and SHOW GRANTS CommandsApply the right privileges per object type, grant access to objects inside a database, and use SHOW commands to review roles…4 min
  5. 5Future Grants, Managed Access Schemas, Cloned Objects and Warehouse GrantsImplement future grants and managed access schemas, understand how cloning affects granted privileges, and manage warehouse…4 min
  6. 6Database Roles and Primary and Secondary RolesUse database roles to scope access to one database, and decide when primary and secondary roles combine privileges in an active…Diagram4 min
  7. 7Auditing User and Query Activity, Fine-Tuning Access and Billing VisibilityAudit users and queries with ACCOUNT_USAGE and ORGANIZATION_USAGE, fine-tune access controls and give non-administrators billing…4 min
  8. 8Account-Level Permissions and Access Control for AI and ML ModelsManage Snowflake account-level privileges such as MANAGE GRANTS and CREATE INTEGRATION and secure access to ML models and Cortex…4 min
  9. 9Snowflake Authentication, Federated SSO and Identity Provider SetupSet up Snowflake authentication, configure a SAML 2.0 identity provider for federated SSO, and manage the integration, login…Diagram4 min
  10. 10Passwords, Password Policies, MFA Enrollment and User TypesManage Snowflake user types, password policies, MFA enrollment, reporting on users without MFA, and password resets or temporary…4 min
  11. 11Key-Pair Authentication, Programmatic Access Tokens and RotationManage Snowflake key-pair authentication and rotation and programmatic access tokens with role restriction, expiry and network…5 min
  12. 12OAuth 2.0 in Snowflake - Snowflake OAuth, External OAuth and Custom ClientsConfigure OAuth 2.0 in Snowflake: compare Snowflake OAuth with External OAuth, set up custom clients and see how network policies…Diagram4 min
  13. 13Network Rules and Network Policy PrecedenceBuild network rules and network policies, know the rule types and modes, and predict which policy wins when account, user and…Diagram5 min
  14. 14Private Connectivity, Internal Stages and the SQL APISet up private endpoints for the Snowflake service and internal stages on AWS, Azure and Google Cloud, and secure and…5 min
  15. 15Security Administration and SCIM ProvisioningWho administers Snowflake security, and how to set up, secure and monitor SCIM so an identity provider creates, updates and…Diagram5 min
  16. 16Exfiltration Controls, Service Authentication and AI AccessStop data leaving through stages, set up service users with key pair and token authentication, and control access to Cortex AI…5 min

About this chapter

What this chapter covers

Snowflake Security, RBAC, and User Administration is the chapter on who may do what in a Snowflake account and how they prove who they are. For the SnowPro Advanced: Administrator ADA-C02 exam it tests decisions, not definitions: which role, which privilege, which view, which authentication method, and why.

Questions are scenarios that start with "An administrator needs to ...". They are single answer, multiple select or interactive, and the right answer usually turns on one detail such as a default, a precedence rule or the role that holds a privilege.

How the topics fit together

Access is built in layers. Roles decide what a session may do, authentication decides who gets a session, and the network decides where it may come from.

Administrative rolesORGADMIN, ACCOUNTADMINbuildRBACcustom roles, grantsaudited withUsage viewsACCOUNT_USAGEprotectAuthenticationSSO, MFA, key pair, OAuthlimited byNetworkpolicies, private connectivity
  • Administrative roles and RBAC cover system roles, custom roles, inheritance, grants, future grants, managed access and database roles.
  • Auditing covers who holds privileges and who used them.
  • Authentication covers federated SSO, passwords, MFA, user types, key pairs, tokens and OAuth.
  • Network and provisioning cover network rules, private connectivity, the SQL API and SCIM on the later pages.
Exam tip

When two answers both look right, pick the one with the narrowest role and the least privilege. The exam rewards least privilege and separation of duties.

How to use these pages

Each topic page has the same shape, so you can skim for what you need.

  • What it is: the idea in plain words.
  • How it works: the mechanism, with diagrams, SQL and comparison tables.
  • Common mistakes: the classic traps.
  • What to remember for the exam: the facts to memorize.
  • Check yourself: three questions to test your understanding.

Read the pages in order the first time. Later pages reuse the roles and grants from the earlier ones.

Ready for more practice?

The full Snowflake ADA-C02 question bank has 814 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.