Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage

GRANTS

Sundeck CATALOG.GRANTS view stores information about grants.

Column NameData TypeDescription
CREATED_ONTEXTTime at which grant was given at
ROLETEXTprivilege given by grant
GRANTED_TOTEXTType to which grant to (currently USER always)
GRANTEE_NAMETEXTuser to which role is granted to
GRANTED_BYTEXTGranted by which Role (currently ADMIN always)

Example:


coral@sundeck.io#COMPUTE_WH@SUNDECK.CATALOG>select * from grants;
+--------------------------------------+-------+------------+-------------------+------------+
| CREATED_ON                           | ROLE  | GRANTED_TO | GRANTEE_NAME      | GRANTED_BY |
|--------------------------------------+-------+------------+-------------------+------------|
| 2023-11-10 10:27:44.123427 +0000 UTC | ADMIN | USER       | coral@sundeck.io | ADMIN      |
+--------------------------------------+-------+------------+-------------------+------------+
1 Row(s) produced. Time Elapsed: 3.742s