Structure

---

CREATE TABLE "Users"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Password" VARCHAR(40) COLLATE "ANSI",
"PasswordLastChanged" TIMESTAMP,
"Description" CLOB COLLATE "ANSI",
"Attributes" CLOB COLLATE "ANSI",
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Users"
("Name")

Description

---

This table contains the defined users in an ElevateDB configuration. Each user may be assigned various roles as well as granted individual privileges. In each new ElevateDB configuration, there is one pre-defined System user that cannot be modified at all, and there is one pre-defined Administrator user that can be modified or deleted. You can find out more about users and privileges in the User Security topic.

Related DDL Statements

---