Set Up Security

In the process of creating a database, you have the option of specifying a Database Superuser password, which permanently enables password authentication for the database. If you choose not to supply a password, the database is permanently set to trust authentication (no password required). This is a one-time-only decision. You cannot enable or disable password authentication later.

1. Create Database Users

   This task involves using the CREATE USER command to create additional database user accounts.

2. Assign Privileges

   This task involves using the GRANT (Schema) and GRANT (Table) commands to grant appropriate access privileges to users.

   In a database with trust authentication, the GRANT and REVOKE statements appear to work as expected but have no actual effect on the security of the database.

Notes

• Newly-created users do not have access to schema PUBLIC by default. Make sure to GRANT USAGE ON SCHEMA PUBLIC to all users you create.