create db from share from different role in reader account Snowflake

Question

I have a share(i.e. shareTest_share) in accountAdmin role in one of my reader accounts in snowflake.

Now I want to create a database from this, but from sysAdmin role.

The statement for creating database is:

CREATE or replace DATABASE shareTest_db FROM SHARE mukulanalytics.shareTest_share

This is giving permission issue since I am trying to execute it from the sysAdmin role instead of accountAdmin role which has the access to shareTest_share share.

Error:

SQL access control error: Insufficient privileges to operate on foreign share 'SHARETEST_SHARE'

How can I create a database from share in a different role with share in another role?

sprethepa · Accepted Answer · 2022-08-11 07:35:13Z

1

You will have to grant the IMPORT SHARE privilege to SYSADMIN/any other users

use role accountadmin

grant import share on account to sysadmin

use role sysadmin

create database TEST from share <>

https://docs.snowflake.com/en/user-guide/security-access-privileges-shares.html

answered Aug 11, 2022 at 7:35

sprethepa

8155 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

NickW · Accepted Answer · 2022-08-11 07:25:31Z

1

the privileges required to achieve this are described here: https://docs.snowflake.com/en/user-guide/security-access-privileges-shares.html

answered Aug 11, 2022 at 7:25

NickW

10k2 gold badges10 silver badges26 bronze badges

Collectives™ on Stack Overflow

create db from share from different role in reader account Snowflake

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related