LIST PRIVILEGES

Syntax

LIST PRIVILEGES

Privileges

USERADMIN

Description

The LIST PRIVILEGES command returns a rowset that contains a list of all the privileges built into SQLite Cloud.

Return

A Rowset with one privilege name column.

Example

> LIST PRIVILEGES
-----------------|
 name            |
-----------------|
 NONE            |
 READ            |
 INSERT          |
 UPDATE          |
 DELETE          |
 READWRITE       |
 PRAGMA          |
 CREATE_TABLE    |
 CREATE_INDEX    |
 CREATE_VIEW     |
 CREATE_TRIGGER  |
 DROP_TABLE      |
 DROP_INDEX      |
 DROP_VIEW       |
 DROP_TRIGGER    |
 ALTER_TABLE     |
 ANALYZE         |
 ATTACH          |
 DETACH          |
 DBADMIN         |
 SUB             |
 PUB             |
 PUBSUB          |
 BACKUP          |
 RESTORE         |
 DOWNLOAD        |
 PLUGIN          |
 SETTINGS        |
 USERADMIN       |
 CLUSTERADMIN    |
 CLUSTERMONITOR  |
 CREATE_DATABASE |
 DROP_DATABASE   |
 HOSTADMIN       |
 ADMIN           |
 PUBSUBCREATE    |
-----------------|