Structure

---

CREATE TABLE "Roles"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Attributes" CLOB COLLATE "ANSI",
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Roles"
("Name")

Description

---

This table contains the defined roles in an ElevateDB configuration. Each role may be assigned to any defined user except for the System user, and each role can be granted privileges. Roles can make administration must simpler by allowing one to grant privileges to a fixed set of roles, and then assign the roles to individual users as necessary. The privileges granted to an individual user along with the privileges inherited from roles that have been granted to the same user, are collectively referred to as the effective privileges for the user. You can find out more information on effective privileges in the User Security topic.

Related DDL Statements

---