This website uses cookies to ensure you get the best experience.
Learn more.
A role has CREATE TABLE on a schema. Does that automatically give it SELECT on every existing table in that schema?
Published
- Only if table names are unquoted
- Yes; schema creation privileges imply every table privilege
- No; creating objects and reading existing objects are distinct privileges
- Only if the warehouse is larger than Small
Comments — 0
Sign in to comment