Neoview Database Administrator's Guide (R2.4)

Considerations for grantRole
• The grantRole 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 grantRole command must be performed by a user belonging to the MGR role.
• The grantRole command affects all segments in the Neoview platform.
• If a user has previously been granted a role, you must first revoke the existing role using
the revokeRole command before you can grant a new role to the user.
Examples for grantRole
This example grants the DBA role to a user named Kathy.
CALL neo.uaf.grantRole ('Kathy', ‘role.dba', ?, ?);
revokeRole Command
The revokeRole command revokes a user's role. The user has only public privileges on the
Neoview platform until a new role is granted with the grantRole command.
Syntax Description for revokeRole
revokeRole {(username,| error,| message)}
;
username
is the name of an existing user whose role you are revoking.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.
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 revokeRole
• The revokeRole 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 revokeRole command must be performed by a user belonging to the MGR role.
• The revokeRole command affects all segments in the Neoview platform.
Examples for revokeRole
This example revokes the current role from a user named Annie.
CALL neo.uaf.revokeRole ('Annie', ?, ?);
changePassword Command
The changePassword command changes a user's password. You do not need to know the user's
existing password.
128 User Management Commands to Manage Multiple Neoview Users