thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

GRANT Statement

The DCL statement that gives privileges on database objects to users or roles.

Definition

GRANT specifies privileges (SELECT, INSERT, UPDATE, EXECUTE and so on), an object and a grantee. WITH GRANT OPTION lets the grantee pass the privilege on. In Snowflake, privileges are granted only to roles, which are then granted to users.

Example

GRANT SELECT, INSERT ON Sales.Orders TO AnalystRole;

Exam tip

In Snowflake you cannot grant object privileges directly to a user; grant them to a role, then grant the role to the user.

Related terms