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
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, ...)

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