Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 



SHOW GRANTS Statement

Description

The SHOW GRANT statement displays the permissions associated with the database user accounts.

Syntax

SHOW GRANTS FOR 'user'

Example

CREATE TABLE testgrant (id int);

CREATE USER user1;

GRANT INSERT,SELECT ON testgrant TO user1;

 

SHOW GRANTS FOR user1;

  Grants for USER1

======================

  'GRANT INSERT, SELECT ON testgrant TO USER1'