PgAccess provides the ability to graphically modify and manage user accounts associated with the database. Like
command-line clients, it uses CREATE USER and ALTER USER to accomplish these tasks.
The difference is that PgAccess provides a graphical front-end to these commands. This feature is available through the
Users tab on the left side of the PgAccess window. Figure 6-2 shows this tab.
Figure 6-2. The PgAccess Users tab
Clicking on Users will display a list of all users associated with the database. Of the
program's three action buttons, only New and Design perform actions from this
Clicking New will allow you to create a new user within the database. As you may notice, the options in this window
correlate with the options available through the use of the SQL command, CREATE USER. Use the
Username field to set the new user's username, and the Password and verify
password fields to set the password (if there will be one). The two check boxes set the
CREATEDB and CREATEUSER permissions for the new user, if checked (remember that
allowing these permissions creates the new user as a database superuser). You may use the Valid until
field to set the valid-until date for the user (the same as the CREATE USER command).
Clicking the Design button allows you to modify the attributes of the selected user account as
you would normally do with the SQL command, ALTER USER. As such, the options here
correlate with the options available through ALTER USER, such as modifying the
username, changing the password, setting the previously mentioned CREATEDB and
CREATEUSER permissions, and modifying the valid-until date.