Services | Access Privileges |
---|---|
Search Optimization services | OWNERSHIP privilege on the table ADD SEARCH OPTIMIZATION privilege on the schema that contains the table |
to query a table | USAGE on db USAGE on schema SELECT on table |
Creating and managing external table | Database - USAGE Schema - USAGE, CREATE STAGE (if creating a new stage), CREATE EXTERNAL TABLE Stage (if using an existing stage) - USAGE |
Data listing | CREATE DATABASE, IMPORT SHARE |
Data Exchange | IMPORTED PRIVILEGES |
Shared DB | IMPORTED PRIVILEGES |