ServicesAccess Privileges
Search Optimization servicesOWNERSHIP privilege on the table
ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
to query a tableUSAGE on db
USAGE on schema
SELECT on table
Creating and managing external tableDatabase - USAGE
Schema - USAGE, CREATE STAGE (if creating a new stage), CREATE EXTERNAL TABLE
Stage (if using an existing stage) - USAGE
Data listingCREATE DATABASE, IMPORT SHARE
Data ExchangeIMPORTED PRIVILEGES
Shared DBIMPORTED PRIVILEGES