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.
- 1Administrative Roles - ORGADMIN, ACCOUNTADMIN and System Role HierarchyManage Snowflake administrative roles: ORGADMIN and ACCOUNTADMIN use cases, system role hierarchy, securing ACCOUNTADMIN and…Diagram5 min
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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 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.
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.