August 2003
Intermediate to advanced
816 pages
28h 15m
English
Each PostgreSQL object (a table, view, index, or sequence) has an owner, who is the user who created it. By default, only the owner can select data from or update records in an object, which is not too useful if your server has multiple users who will all need access to the same tables. Fortunately, it is possible to grant access to database objects to other users or groups by following these steps:
1. | On the module's main page, click on the Granted Privileges icon. Assuming you actually have some tables in your databases, this will bring up a page listing all existing objects and their current permissions. |
2. | Click on the name of the object to which you want to grant access, which will take you to its privileges ... |
Read now
Unlock full access