Permissions you can grant to datashares
Different object types and various permissions you can grant to them in a data sharing context.
Databases:
-
CREATE
-
USAGE
-
ALTER
-
DROP
Schemas:
-
CREATE
-
USAGE
-
ALTER
-
DROP
Tables:
-
SELECT
-
INSERT
-
UPDATE
-
DELETE
-
TRUNCATE
-
DROP
-
ALTER
-
REFERENCES
Functions:
-
EXECUTE