Icon StorePrivileges Table

Structure
CREATE TABLE "StorePrivileges"
(
"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 "StorePrivileges"
("Name")
   
CREATE INDEX "GrantedTo" ON "StorePrivileges"
("GrantedTo")

Description
This table contains the store privileges assigned to the users in an ElevateDB configuration. 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