SYS.PRIVILEGES

The sys.privileges table contains metadata for privileges for objects in the Dremio instance.

Syntax

SELECT * 
FROM sys.privileges

Example Output

note

For object_type, PDS indicates a table and VDS indicates a view.

grantee_id	grantee_type	privilege	object_id	object_type
test_user	user	ALTER	"@test_user"."nyc_taxi"	PDS
test_user	user	SELECT	"@test_user"."nyc_taxi"	PDS
test_user	user	SELECT	"@test_user".remove_spaces	FUNCTION
test_role	role	SELECT	"reporting"."nyc_taxi_2022"	VDS
test_user2	user	ALTER	"reporting".test	FOLDER
admin_user	user	MODIFY	"Samples"	SOURCE
admin_user	user	CREATE_USER	empty text	SYSTEM
test_user2	user	MANAGE_GRANTS	2abbe93f-726b-4be6-81d5-f1ed6919a458	SCRIPT
test_user2	user	MODIFY	20b8dbc6-0530-49a4-a2d4-6cc24d6663e9	SCRIPT

Fields

Field	Data Type	Description
grantee_id	varchar	The user or role name for which the object has been granted.
grantee_type	varchar	The type of object that the privilege is granted to. Enum: user, role
privilege	varchar	The privilege granted on the object to the grantee.
object_id	varchar	The name or UUID of the object on which the privilege has been granted.
object_type	varchar	The type of the object on which the privilege has been granted.