pub enum GrantObjects {
Show 28 variants
AllSequencesInSchema {
schemas: Vec<ObjectName>,
},
AllTablesInSchema {
schemas: Vec<ObjectName>,
},
AllViewsInSchema {
schemas: Vec<ObjectName>,
},
AllMaterializedViewsInSchema {
schemas: Vec<ObjectName>,
},
AllExternalTablesInSchema {
schemas: Vec<ObjectName>,
},
AllFunctionsInSchema {
schemas: Vec<ObjectName>,
},
FutureSchemasInDatabase {
databases: Vec<ObjectName>,
},
FutureTablesInSchema {
schemas: Vec<ObjectName>,
},
FutureViewsInSchema {
schemas: Vec<ObjectName>,
},
FutureExternalTablesInSchema {
schemas: Vec<ObjectName>,
},
FutureMaterializedViewsInSchema {
schemas: Vec<ObjectName>,
},
FutureSequencesInSchema {
schemas: Vec<ObjectName>,
},
Databases(Vec<ObjectName>),
Schemas(Vec<ObjectName>),
Sequences(Vec<ObjectName>),
Tables(Vec<ObjectName>),
Views(Vec<ObjectName>),
Warehouses(Vec<ObjectName>),
Integrations(Vec<ObjectName>),
ResourceMonitors(Vec<ObjectName>),
Users(Vec<ObjectName>),
ComputePools(Vec<ObjectName>),
Connections(Vec<ObjectName>),
FailoverGroup(Vec<ObjectName>),
ReplicationGroup(Vec<ObjectName>),
ExternalVolumes(Vec<ObjectName>),
Procedure {
name: ObjectName,
arg_types: Vec<DataType>,
},
Function {
name: ObjectName,
arg_types: Vec<DataType>,
},
}Expand description
Objects on which privileges are granted in a GRANT statement.
Grant privileges on ALL SEQUENCES IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on ALL TABLES IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on ALL VIEWS IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on ALL MATERIALIZED VIEWS IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on ALL EXTERNAL TABLES IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on ALL FUNCTIONS IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on FUTURE SCHEMAS IN DATABASE <database_name> [, ...]
Fields
The target database names.
Grant privileges on FUTURE TABLES IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on FUTURE VIEWS IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on FUTURE EXTERNAL TABLES IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on FUTURE MATERIALIZED VIEWS IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on FUTURE SEQUENCES IN SCHEMA <schema_name> [, ...]
Fields
Grant privileges on specific databases
Grant privileges on specific schemas
Grant privileges on specific sequences
Grant privileges on specific tables
Grant privileges on specific views
Grant privileges on specific warehouses
Grant privileges on specific integrations
Grant privileges on resource monitors
Grant privileges on users
Grant privileges on compute pools
Grant privileges on connections
Grant privileges on failover groups
Grant privileges on replication group
Grant privileges on external volumes
Grant privileges on a procedure. In dialects that support overloading, the argument types must be specified.
For example:
GRANT USAGE ON PROCEDURE foo(varchar) TO ROLE role1
Fields
Optional argument types for overloaded procedures.
Grant privileges on a function. In dialects that support overloading, the argument types must be specified.
For example:
GRANT USAGE ON FUNCTION foo(varchar) TO ROLE role1
Fields
Optional argument types for overloaded functions.