Neoview Database Administrator's Guide (R2.4)

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.) If expirationDate
is the current date and the system grace period is greater than zero, then a user using
username is required to change the password in order to logon. This is a required input
parameter.
expirationDate is a single-quoted space-delimited string in the form of:
month-name day year
month-name
is the first three letters of the month name and is not case-sensitive. For example: JAN,
feb, Mar
day
is a one or two digit integer from 1 through 31, specifying the day of the month.
year
is a 4-digit integer to specify the year, or spaces to specify no expiration date.
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 createUser
• The createUser 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 createUser command must be performed by a user belonging to the MGR role.
• The createUser command affects all segments in the Neoview platform.
• If you specify a value for expirationDays and a value for expirationDate, password
expiration is based on the value that expires first.
Examples for createUser
• This example creates a user named Kathy with the password Boulder given the role of MGR,
which will expire every 90 days with no expiration date specified.
CALL neo.uaf.createUser ('Kathy', 'Boulder', 'role.mgr', 90, ' ', ?, ?);
• This example creates a user named Annie with the password LittleOrphan given the role
of DBA with the expiration date of January 10, 2009.
CALL neo.uaf.createUser ('Annie', 'LittleOrphan', 'role.dba', 0, 'jan 10 2009', ?, ?);
• In this example, if the command is executed on February 9th, 2008, it creates a user named
Joe with the password Temporary given the role of DBA with an immediate expiration (Joe
must change his password at first logon) and then expiring every 365 days thereafter.
CALL neo.uaf.createUser ('Joe', ‘Temporary’, 'role.dba', 365, 'feb 9 2008', ?, ?);
dropUser Command
The dropUser command drops a user from the Neoview platform.
Syntax Description for dropUser
dropUser {(username,| error,| message)}
;
126 User Management Commands to Manage Multiple Neoview Users