Icon Users Table

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
StatementDescription
CREATE USERCreates a new user
ALTER USERAlters an existing user
DROP USERDrops an existing user
RENAME USERRenames an existing user
Image