Go Up to Database User Management
Connecting to a database does not automatically include privileges to modify or even view data stored within that database. Privileges must be granted explicitly; users cannot access any database objects until they have been granted privileges. Privileges granted to
PUBLIC apply to all users.
For full description of syntax of SQL privileges, see entries for
ROLE in the Language Reference and Data Definition Guide.