I have access to our tables, but I can't run queries on them

Jason Harris

• April 05, 2018 02:05

I get the message “permission denied for relation pardotvisitoractivity”. What’s going on?

0

• 

  Sam

  • April 05, 2018 02:06

  By default, only the owner of the schema a user creates by running create schema foo can read from schema foo. The owner needs to explicitly grant privileges to other users so they can read from this schema.

  This commonly occurs when users are trying to set up looker connections and are creating the looker_scratch schema.

  0

Please sign in to leave a comment.