Neoview Database Administrator's Guide (R2.4)

C User Management Commands to Manage Multiple
Neoview Users
Commands to Manage Multiple Neoview Users
You can manage multiple users at a time on the Neoview platform with five Neoview user
management commands. These commands are executed using a CALL statement from Neoview
Script:
• createUser
• dropUser
• grantRole
• revokeRole
• changePassword
For error messages returned by these commands, see “Messages for User Management
Commands” (page 130).
NOTE: The minimum supported Neoview release for these commands is R2.3, SP3.
createUser Command
The createUser command creates a user on the Neoview platform.
Syntax Description for createUser
createUser {(username,| password,| rolename,| expirationDays,| expirationDate,| error,| message)}
;
expirationDate is
{month-name|day|year}|
username
is the user name to be added to the platform. The name must be unique on the local platform.
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.
password
is the new password to associate with this user name. password is a case-sensitive,
single-quoted string of 0 (zero) to 64 characters containing any alphanumeric character except
space, comma (,), semicolon (;), double quote (“), or ASCII null. Password length is governed
by Neoview DBAdmin password control policies. 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 parameter.
expirationDays
the number of days at the end of which password expires. If the platform grace period for
password changes is zero, then the ability for this username to log on is suspended.
Otherwise, username can log on for the number of days specified by the platform grace
period, provided the password is changed during the logon. (See the Neoview Database
Administrator's Guide for more information about the platform grace period for password
changes.) expirationDays is an integer from 0 (zero) through 32767. A zero value specifies
no expiration. This is a required input parameter.
expirationDate
the date on which the password expires. If the platform grace period for password changes
is zero, then the ability for this username to log on is suspended. Otherwise, user-name
Commands to Manage Multiple Neoview Users 125