SQL User Security DDL Flashcards

1
Q

ALTER API INTEGRATION

A

Modifies the properties of an existing API integration.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ALTER NETWORK POLICY

A

Modifies the properties for an existing network policy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ALTER NOTIFICATION INTEGRATION

A

Modifies the properties for an existing notification integration.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

ALTER ROLE

A

Modifies the properties for an existing role.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ALTER SECURITY INTEGRATION

A

Modifies the properties for an existing security integration.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

ALTER SECURITY INTEGRATION (External OAuth)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

ALTER SECURITY INTEGRATION (Snowflake OAuth)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

ALTER SECURITY INTEGRATION (SAML2)

A

Modifies the properties of an existing SAML2 security integration.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

ALTER SECURITY INTEGRATION (SCIM)

A

Modifies the properties of an existing SCIM security integration.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

ALTER SESSION POLICY

A

Modifies the properties for an existing session policy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

ALTER STORAGE INTEGRATION

A

Modifies the properties for an existing storage integration.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

ALTER TAG

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

ALTER USER

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

CREATE API INTEGRATION

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

CREATE NETWORK POLICY

A

Creates a network policy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

CREATE NOTIFICATION INTEGRATION

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

CREATE ROLE

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

CREATE SECURITY INTEGRATION

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

CREATE SECURITY INTEGRATION (External OAuth)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

CREATE SECURITY INTEGRATION (Snowflake OAuth)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

CREATE SECURITY INTEGRATION (SAML2)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

CREATE SECURITY INTEGRATION (SCIM)

A

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

23
Q

CREATE SESSION POLICY

A

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

24
Q

CREATE STORAGE INTEGRATION

A

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

25
Q

CREATE TAG

A

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

26
Q

CREATE USER

A

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

27
Q

DESCRIBE INTEGRATION

A

Describes the properties of an integration.

28
Q

DESCRIBE NETWORK POLICY

A

Describes the properties specified for a network policy.

29
Q

DESCRIBE SESSION POLICY

A

Describes the details about a session policy.

30
Q

DESCRIBE USER

A

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

31
Q

DROP INTEGRATION

A

Removes an integration from the account.

32
Q

DROP NETWORK POLICY

A

Removes the specified network policy from the system.

33
Q

DROP ROLE

A

Removes the specified role from the system.

34
Q

DROP SESSION POLICY

A

Removes a session policy from the system.

35
Q

DROP TAG

A

Removes a tag from the system.

36
Q

DROP USER

A

Removes the specified user from the system.

37
Q

GRANT OWNERSHIP

A

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

38
Q

GRANT … TO ROLE

A

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

39
Q

GRANT … TO SHARE

A

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

40
Q

GRANT ROLE

A

Assigns a role to a user or another role.

41
Q

REVOKE … FROM ROLE

A

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

42
Q

REVOKE … FROM SHARE

A

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

43
Q

REVOKE ROLE

A

Removes a role from another role or a user.

44
Q

SHOW DELEGATED AUTHORIZATIONS

A

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

45
Q

SHOW GRANTS

A

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

46
Q

SHOW INTEGRATIONS

A

Lists the integrations in your account.

47
Q

SHOW NETWORK POLICIES

A

Lists all network policies defined in the system.

48
Q

SHOW ROLES

A

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

49
Q

SHOW SESSION POLICIES

A

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

50
Q

SHOW TAGS

A

Lists the tag information.

51
Q

SHOW USERS

A

Lists all users in the system.

52
Q

UNDROP TAG

A

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

53
Q

USE ROLE

A

Specifies the active/current primary role for the session.

54
Q

USE SECONDARY ROLES

A

Specifies the active/current secondary roles for the session.