Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-06-2023 05:27 AM
Hello Hubert & Jfoxyyc,
For granting user permission to a table I am using following 3 grants statements
grant usage on catalog demo_catalog to `user@***.com`
grant usage on schema demo_catalog.demo_schema to `user@***.com`
grant select on table demo_catalog.demo_schema.demo_table to `user@***.com`
Is there a way to grant this permission with single grant statement? Thanks in advance.