Icon ViewPrivileges Table

Structure
CREATE TABLE "ViewPrivileges"
(
"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 "ViewPrivileges"
("Name")

CREATE INDEX "GrantedTo" ON "ViewPrivileges"
("GrantedTo")

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