Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage
  1. Docs
  2. /
  3. Reference
  4. /
  5. Sundeck DDL
  6. /
  7. SHOW SUNDECK GRANTS

SHOW SUNDECK GRANTS

Lists all Sundeck access control privileges that have been explicitly granted to user.

See also:
GRANT SUNDECK ROLE, REVOKE SUNDECK ROLE

Syntax 

SHOW SUNDECK GRANTS;

Example: 

vicky#COMPUTE_WH@(no database).(no schema)>show sundeck grants;
+--------------------------------------+-------+------------+--------------+------------+
| CREATED_ON                           | ROLE  | GRANTED_TO | GRANTEE_NAME | GRANTED_BY |
|--------------------------------------+-------+------------+--------------+------------|
| 2023-11-14 20:29:09.117026 +0000 UTC | ADMIN | USER       | VICKY        | ADMIN      |
| 2023-11-14 20:29:39.871583 +0000 UTC | ADMIN | USER       | TEST         | ADMIN      |
+--------------------------------------+-------+------------+--------------+------------+
2 Row(s) produced. 

vicky#COMPUTE_WH@(no database).(no schema)>revoke sundeck role admin from user test;  
+---------+                                                                     
| status  |
|---------|
| SUCCESS |
+---------+
1 Row(s) produced. 

vicky#COMPUTE_WH@(no database).(no schema)>show sundeck grants;
+--------------------------------------+-------+------------+--------------+------------+
| CREATED_ON                           | ROLE  | GRANTED_TO | GRANTEE_NAME | GRANTED_BY |
|--------------------------------------+-------+------------+--------------+------------|
| 2023-11-14 20:29:09.117026 +0000 UTC | ADMIN | USER       | VICKY        | ADMIN      |
+--------------------------------------+-------+------------+--------------+------------+
1 Row(s) produced.