SYS.ORGANIZATION.PRIVILEGES

The sys.organization.privileges table contains metadata for privileges at the organization-level. To access project-level privileges, see the sys.project.privileges table.

Syntax

SELECT * 
FROM sys.organization.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
[email protected]	user	ALTER	@[email protected]	VDS
[email protected]	user	SELECT	@[email protected]	VDS
PUBLIC	role	ENGINE	firstEngine	USAGE
PUBLIC	role	ENGINE	preview	USAGE
[email protected]	user	OWNERSHIP	acme corporation org	ORG
[email protected]	user	OWNERSHIP	reflections-engine	ENGINE
[email protected]	user	OWNERSHIP	default-cloud	CLOUD
[email protected]	user	OWNERSHIP	dev-project	PROJECT

Columns

Column	Data Type	Description
grantee_id	varchar	The user or role to 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 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.