Permission control on snowflake imported database

Question

I have one imported database in snowflake, which contains multiple tables. How can I grant one user access to one subset of tables, grant another user to another set of tables? It seems that I can’t grant table level access on a imported database.

Snowflake. I expected table level permissions on an imported database

NickW · Accepted Answer · 2025-06-28 20:06:47Z

2

You would need the DB provider to create the required RBAC using DB roles.

Alternatively (and this is less than ideal) you could create your own DB with views that referenced the shared DB - and create your RBAC on that DB

answered Jun 28 at 20:06

NickW

10k2 gold badges10 silver badges26 bronze badges

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

2 Comments

Yanchao Guo Jun 29 at 5:18

Where to look for the provider created RBAC? I can't find them, does it mean provider didn't create them?

NickW Jun 29 at 9:37

If the shared database doesn't have any database roles then the provider hasn’t included an RBAC - but I’d probably start by asking them

Collectives™ on Stack Overflow

Permission control on snowflake imported database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related