Neoview Database Administrator's Guide (R2.4)

username
is the user name to be dropped from the platform. username is a case-sensitive single quoted
text string, with a maximum of 32 alphanumeric characters and special characters period (.),
hyphen (-), and underscore (_). The first character of a user name must be alphabetic or
numeric. User names may not begin with the string “role”. This is a required input parameter.
error
contains the error numbers if an error occurs. If no error occurs, this field is 0. This is a required
parameter reserved for output, and is represented by a question-mark (?).
message
contains the text related to the outcome of the command. If an error occurs, this text pertains
to the error. This is a required parameter reserved for output, and is represented by a
question-mark (?).
Considerations for dropUser
• The dropUser command is created in the catalog.schema named neo.uaf. You must either
precede the command name with this catalog and schema name or set the default
catalog.schema to neo.uaf first: SET SCHEMA neo.uaf;
• The dropUser command must be performed by a user belonging to the MGR role.
• The dropUser command affects all segments in the Neoview platform.
Examples for dropUser
This example drops a user named David.
CALL neo.uaf.dropUser ('David', ?, ?);
grantRole Command
The grantRole command grants a role to a Neoview user. A user can be assigned only one role
at a time.
Syntax Description for grantRole
grantRole {(username,| rolename, | error,| message)}
;
username
is the name of an existing user that receives the newly-granted role. username is a
case-sensitive single quoted text string, with a maximum of 32 alphanumeric characters and
special characters period (.), hyphen (-), and underscore (_). User names may not begin with
the string “role”. This is a required input parameter.
rolename
is the name of the role to associate with this user. rolename is a single-quoted string and
must already exist. This is a required input .
error
contains the error numbers if an error occurs. If no error occurs, this field is 0. This is a required
reserved for output, and is represented by a question-mark (?).
message
contains the text related to the outcome of the command. If an error occurs, this text pertains
to the error. This is a required reserved for output, and is represented by a question-mark
(?).
Commands to Manage Multiple Neoview Users 127