User Managment

See also the Role Management topic

 

This function is only available to the SQL Role RDB$ADMIN or the special User SYSDBA.

 

snip-clip0001The ability to add and delete users is reserved for the special user SYSDBA or those users assigned the RDB$ADMIN role. All other users will see the buttons associated with these actions as disabled and only see themselves in the list.

 

Assigning the RDB$ADMIN role is only done by the SYSTEM ADMINISTRATOR. It is not sufficient and cannot be achieved by Granting the RDB$ADMIN role to a user in the User List.

 

All users are listed in this view. Roles for each user are displayed separately with a green tick under the 'Set' column of the role.

 

Double click on a user ID to open a user details edit dialog. When finished, click OK to save your edits. Alternatively, select a user ID and click the Edit Details button to open the same edit details dialog.

 

Reports are available for the entire list or for the currently selected role.

 

Use the tick box adjacent to the user ID to action multiple deletes.


 

Edit user details as shown below. This edit form is available to all users to edit their own information.

The Add User form is similar except that the selected USERID is ready for creation of a new user.

 

Note: Do not add the domain extension e.g. @services.nsw.gov.au to the email address field.

 

Group number is 0 by default and is has no utility as this time.

 

Roles:

Every new user is created with the MANAGER (Cost Monitor) or ENQUIRER (PCC) role by default. It is not possible to have a user with no role. Te system will reject attempt to revoke this lowest role from a user.

 

MANAGER (CM) or ENQUIRER (PCC): A Manager or Enquirer has read-only rights to the database. No editing of information is possible.

 

OPERATOR (CM) or DESKTOPUSER (PCC): Operators have access to the project details screens as their primary point of access and have full read and write access to project creation, allocation and expediting functions. Access to ACCOUNTS function is not possible with this role.

 

ACCOUNTS (CM): The Accounts role provides access to the accounts functions (purchase order invoice entry and posting) as their primary point of access. Access to the Job Status screen is not possible. The Accounts role also has access to contract administration screens, schedule rate items, client contact details and setup.

 

ACCOUNTS (PCC): In PCC, the ACCOUNTS role is limited to By-Product Sales functions.

 

DBADMIN: The DBADMIN role has access to all functions of both the OPERATOR and ACCOUNTS roles. In addition, it has access to application look-up tables and system wide settings.

 

APPOFFICER, CONTADMIN: are roles specific to Cost Monitor when use of the Purchase Order module. The APPOFFICER role is used for purchase Order approvals.

 

PROJOFFICER: is the minimum role for use of the Estimates role in Cost Monitor. Once an estimate is finalised, a PROJOFFICER may cost code the estimate items and export the Estimate to the Cost Control module for project management.

 

snip-clip0002

The default password inserted into the Add User dialog is bgroup

 

This password should be set/changed and both copies (Password and Confirm) should match. If they do not match the User Add function (OK button action) will be rejected.

 

When users change their password, an audit record is maintained which shows the last date/time the password was changed. A user is warned when their password has not been changed in the last 30 days (Cost Monitor only).