Icon TablePrivileges Table

Structure
CREATE TABLE "TablePrivileges"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Privilege" VARCHAR(15) COLLATE "ANSI_CI",
"GrantedTo" VARCHAR(40) COLLATE "ANSI_CI",
"GrantedBy" VARCHAR(40) COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "TablePrivileges"
("Name")
   
CREATE INDEX "GrantedTo" ON "TablePrivileges"
("GrantedTo")

Description
This table contains the table privileges assigned to the users in an ElevateDB configuration for the tables contained within an ElevateDB database. You can find out more about users and privileges in the User Security topic.

Related DDL Statements
StatementDescription
GRANT PRIVILEGESGrants privileges to an existing user
REVOKE PRIVILEGESRevokes privileges from an existing user
Image