Commands available from user interface level

The following operations can be performed from the user interface level, via the context menu of the database alias.

Show Processes

Opens a list of all processes currently running on the database

  • To terminate a process select it in the list and choose Kill from the context menu. This is equivalent to issuing the KILL PROCESS command.

Show Users

Opens a list of all users created for this database.

  • To change user properties tick or untick the check boxes in appropriate columns. Specifically, to create a new administrator tick the check box in the admin column.

  • To add a new user click the right mouse button anywhere in the user list and select Add User from the context menu.

  • To clear the password for a given user select the row corresponding to this user and choose Clear Password from the context menu.

  • To delete a user select the row corresponding to this user and choose Delete User from the context menu.

Note

For non-administrators the Show Users command will display a list of all users, but only the properties of the current user will be visible. A non-administrator user can only choose the Clear Password command to clear his/her own password.

Set Password

Opens a dialog box for changing the password for the current user.