PRIVTYPES System Table Description

Description

A static list grantable privileges.
This is a static table that does not change based on actions in the database. It would rarely change from one NuoDB release to the next.

Fields

Field Type Description

Field	Type	Description
ID	integer	An integer specifying the type: `SELECT`= 2 `INSERT`= 4 `UPDATE`= 8 `DELETE`= 16 `GRANT`= 32 `ALTER`= 64 `EXECUTE`= 128 `TRIGGERS`=256 `PROCEDURES`= 512 `CREATE`= 1024
NAME	varchar(128)	The name of the grantable privilege type (`SELECT`, `INSERT`, …)

integer

An integer specifying the type:

SELECT= 2
INSERT= 4
UPDATE= 8
DELETE= 16
GRANT= 32
ALTER= 64
EXECUTE= 128
TRIGGERS=256
PROCEDURES= 512
CREATE= 1024

NAME

varchar(128)

The name of the grantable privilege type (SELECT, INSERT, …)

Indexes

None

Example

SELECT * FROM system.privtypes;

 ID     NAME
 --- ----------
   2 SELECT
   4 INSERT
   8 UPDATE
  16 DELETE
  32 GRANT
  64 ALTER
 128 EXECUTE
 256 TRIGGERS
 512 PROCEDURES
1024 CREATE