1

While exploring Snowflake documentation on Audit Logging (user login history, object creation/deletion, query execution history etc), I found the below information.

enter image description here

But in my trail account, I didn't find any shared DB with name 'SNOWFLAKE'.

Would apreciate if someone can throw more light on this feature.

Neeraj

Neeraj Kumar
  • 215
  • 3
  • 13
  • In the same documentation, there is a note: "By default, only account administrators (users with the ACCOUNTADMIN role) can access the SNOWFLAKE database and schemas within the database, or perform queries on the views; however, privileges on the database can be granted to other roles in your account to allow other users to access the objects. For more details, see Enabling Account Usage for Other Roles (in this topic)." – Suzy Lockwood Feb 07 '20 at 01:22

3 Answers3

1

You need to choose the 'ACCOUNTADMIN' role in the context of your session to see that database.

Cedersved
  • 1,015
  • 1
  • 7
  • 21
1

You should set the ACCOUNTADMIN role in the context to access the SNOWFLAKE database.

Alternatively, As accountadmin, you can grant the privilege for viewing the data to other users as below.

Grant imported privileges on database snowflake to ; -- where is an existing/new role granted to

sprethepa
  • 544
  • 2
  • 4
0

Changing the role in right upper corner is not sufficient. Yo uneed to change the role in the context.

After that, 'SNOWFLAKE' shared DB will be visible.

Neeraj Kumar
  • 215
  • 3
  • 13