GRANT ALL PRIVILEGES ON DATABASE my_database TO USER my_user; 授予用户对特定表的读取权限: GRANT SELECT ON TABLE my_table TO USER my_user; 授予用户对特定表的写入权限: GRANT INSERT, UPDATE, DELETE ON TABLE my_table TO USER my_user; 授予用户对特定表的DDL权限: GRANT ALTER, DROP ON TABLE...
GRANT { { globalPrivileges | ALL [ PRIVILEGES ] } ON ACCOUNT | { accountObjectPrivileges | ALL [ PRIVILEGES ] } ON { USER | RESOURCE MONITOR | WAREHOUSE | COMPUTE POOL | DATABASE | INTEGRATION | CONNECTION | FAILOVER GROUP | REPLICATION GROUP | EXTERNAL VOLUME } <object_name> | { sch...
For 1, my hunch is that this GRANT USAGE only happens within a minory of data teams, for reasons like: the "production" Snowflake account to which they grant select access has an evolving set of databases and schema so that this problem isn't something that's addressed once on a single...