Manitou-Mail Wiki

User Tools

Site Tools

Trace:
schema_0_9_10_grants

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
schema_0_9_10_grants [2008/11/08 17:16] – danielschema_0_9_10_grants [2008/11/08 17:23] – daniel
Line 4: Line 4:
   * One dedicated database user is the owner of the database and all its objects. This is the user that runs the initial creation script.   * One dedicated database user is the owner of the database and all its objects. This is the user that runs the initial creation script.
   * One or several roles (=groups) are created with //CREATE ROLE// commands.   * One or several roles (=groups) are created with //CREATE ROLE// commands.
-  * Access rights are affected to each role for each database object (tables, functions, sequences, views) with //GRANT SELECT,INSERT,...// commands.+  * Access rights are assigned to each role for each database object (tables, functions, sequences, views) with //GRANT SELECT,INSERT,...// commands.
   * Per-user account are created with //CREATE USER// commands.   * Per-user account are created with //CREATE USER// commands.
   * user logins are inserted into the ''users'' table. It is not mandatory, but skipping this step will prevent the user interface to trace who does what.   * user logins are inserted into the ''users'' table. It is not mandatory, but skipping this step will prevent the user interface to trace who does what.
schema_0_9_10_grants.txt · Last modified: 2008/11/08 18:02 by daniel