SQL User Security DDL

Question 1

ALTER API INTEGRATION

Answer 1

Modifies the properties of an existing API integration.

Question 2

ALTER NETWORK POLICY

Answer 2

Modifies the properties for an existing network policy.

Question 3

ALTER NOTIFICATION INTEGRATION

Answer 3

Modifies the properties for an existing notification integration.

Question 4

ALTER ROLE

Answer 4

Modifies the properties for an existing role.

Question 5

ALTER SECURITY INTEGRATION

Answer 5

Modifies the properties for an existing security integration.

Question 6

ALTER SECURITY INTEGRATION (External OAuth)

Answer 6

Modifies the properties of an existing security integration created for External OAuth.

Question 7

ALTER SECURITY INTEGRATION (Snowflake OAuth)

Answer 7

Modifies the properties of an existing security integration created for a Snowflake OAuth client.

Question 8

ALTER SECURITY INTEGRATION (SAML2)

Answer 8

Modifies the properties of an existing SAML2 security integration.

Question 9

ALTER SECURITY INTEGRATION (SCIM)

Answer 9

Modifies the properties of an existing SCIM security integration.

Question 10

ALTER SESSION POLICY

Answer 10

Modifies the properties for an existing session policy.

Question 11

ALTER STORAGE INTEGRATION

Answer 11

Modifies the properties for an existing storage integration.

Question 12

ALTER TAG

Answer 12

Modifies the properties for an existing tag, including renaming the tag.

Question 13

ALTER USER

Answer 13

Modifies the properties and object/session parameters for an existing user in the system.

Question 14

CREATE API INTEGRATION

Answer 14

Creates a new API integration object in the account, or replaces an existing API integration.

Question 15

CREATE NETWORK POLICY

Answer 15

Creates a network policy.

Question 16

CREATE NOTIFICATION INTEGRATION

Answer 16

Creates a new notification integration in the account or replaces an existing integration.

Question 17

CREATE ROLE

Answer 17

Create a new role or replace an existing role in the system.

Question 18

CREATE SECURITY INTEGRATION

Answer 18

Creates a new security integration in the account or replaces an existing integration.

Question 19

CREATE SECURITY INTEGRATION (External OAuth)

Answer 19

Creates a new External OAuth security integration in the account or replaces an existing integration.

Question 20

CREATE SECURITY INTEGRATION (Snowflake OAuth)

Answer 20

Creates a new Snowflake OAuth security integration in the account or replaces an existing integration.

Question 21

CREATE SECURITY INTEGRATION (SAML2)

Answer 21

Creates a new SAML2 security integration in the account or replaces an existing integration.

Question 22

CREATE SECURITY INTEGRATION (SCIM)

Answer 22

Creates a new SCIM security integration in the account or replaces an existing integration.

Question 23

CREATE SESSION POLICY

Answer 23

Creates a new session policy or replaces an existing session policy.

Question 24

CREATE STORAGE INTEGRATION

Answer 24

Creates a new storage integration in the account or replaces an existing integration.

Question 25

CREATE TAG

Answer 25

Creates a new tag or replaces an existing tag in the system.

Question 26

CREATE USER

Answer 26

Creates a new user or replaces an existing user in the system.

Question 27

DESCRIBE INTEGRATION

Answer 27

Describes the properties of an integration.

Question 28

DESCRIBE NETWORK POLICY

Answer 28

Describes the properties specified for a network policy.

Question 29

DESCRIBE SESSION POLICY

Answer 29

Describes the details about a session policy.

Question 30

DESCRIBE USER

Answer 30

Describes a user, including the current values for the user’s properties, as well as the default values.

Question 31

DROP INTEGRATION

Answer 31

Removes an integration from the account.

Question 32

DROP NETWORK POLICY

Answer 32

Removes the specified network policy from the system.

Question 33

DROP ROLE

Answer 33

Removes the specified role from the system.

Question 34

DROP SESSION POLICY

Answer 34

Removes a session policy from the system.

Question 35

DROP TAG

Answer 35

Removes a tag from the system.

Question 36

DROP USER

Answer 36

Removes the specified user from the system.

Question 37

GRANT OWNERSHIP

Answer 37

Transfers ownership of an object (or all objects of a specified type in a schema) from one role to another role.

Question 38

GRANT … TO ROLE

Answer 38

Grants one or more access privileges on a securable object to a role.

Question 39

GRANT … TO SHARE

Answer 39

Grants access privileges for databases and other supported database objects (schemas, UDFs, tables, and views) to a share.

Question 40

GRANT ROLE

Answer 40

Assigns a role to a user or another role.

Question 41

REVOKE … FROM ROLE

Answer 41

Removes one or more privileges on a securable object from a role.

Question 42

REVOKE … FROM SHARE

Answer 42

Revokes access privileges for databases and other supported database objects (schemas, tables, and views) from a share.

Question 43

REVOKE ROLE

Answer 43

Removes a role from another role or a user.

Question 44

SHOW DELEGATED AUTHORIZATIONS

Answer 44

Lists the active delegated authorizations for which you have access privileges.

Question 45

SHOW GRANTS

Answer 45

Lists all access control privileges that have been explicitly granted to roles, users, and shares.

Question 46

SHOW INTEGRATIONS

Answer 46

Lists the integrations in your account.

Question 47

SHOW NETWORK POLICIES

Answer 47

Lists all network policies defined in the system.

Question 48

SHOW ROLES

Answer 48

Lists all the roles which you can view across your entire account, including the system-defined roles and any custom roles that exist.

Question 49

SHOW SESSION POLICIES

Answer 49

Lists session policy information, including the creation date, database and schema names, owner, and any available comments.

Question 50

SHOW TAGS

Answer 50

Lists the tag information.

Question 51

SHOW USERS

Answer 51

Lists all users in the system.

Question 52

UNDROP TAG

Answer 52

Restores the most recent version of a tag to the system.

Question 53

USE ROLE

Answer 53

Specifies the active/current primary role for the session.

Question 54

USE SECONDARY ROLES

Answer 54

Specifies the active/current secondary roles for the session.