Structure

---

CREATE TABLE "UserRoles"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"GrantedTo" VARCHAR(40) COLLATE "ANSI_CI",
"GrantedBy" VARCHAR(40) COLLATE "ANSI_CI",
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

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

Description

---

This table contains the roles assigned to the users in an ElevateDB configuration. You can find out more about users and roles in the User Security topic.

Related DDL Statements

---