Configuring non Administrator access for PSC ODBC driver.

Problem:
By default, the PSC database has only one user, Administrator (assuming it was installed using Administrator). This can cause security issues by having Administrator credentials in clear text form on server.
Solution:

1. Using PSC SQL Explorer, connect via Administrator, then create at least one SQL Admin user as follows:

CREATE USER 'SQLAdmin', 'SQLAdmin'; (This creates a SQL user SQLAdmin with pw: SQLAdmin)

COMMIT;

2. Grant dba authority to the user as follows:

GRANT DBA to SQLAdmin;

COMMIT;

This Admin user can access all tables in any fashion as desired.

If desired, create other dba and non dba SQL users. For non dba users, explicit permission must be granted to read or write tables, as follows:

GRANT ALL ON PUB.tablename TO Username;

...

COMMIT;