Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

Question

jing xue · Accepted Answer

CREATE NETWORK POLICY ADMIN_POLICY ALLOWED IP LIST = ('192.168.1.100') BLOCKED_IP_LIST = ('0.0.0.0/0'); ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

jing xue · Answer

CREATE NETWORK POLICY ADMIN_POLICY ALLOWED_IP_LIST = ('192.168.1.100'); ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY'; User ABC is the only user with an ACCOUNTADMIN role.

jing xue · Answer

CREATE NETWORK POLICY ADMIN POLICY ALLOWED_IP_LIST = ('192.168.1.100'); ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY';

jing xue · Answer

CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY ALLOWED_IP_LIST = ('192.168. 1. 100/0') ; ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 20 - ADA-C01 discussion

Suggested answer: C

0 comments