User Tools

Site Tools


This is an old revision of the document!

Schema access rights

The policy for dealing with access rights is left to the administrator and exercised using SQL commands, as is the creation of database users.
This page gives some basic guidelines on how to manage a database with multiple users in a typical scenario:

  • 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 groups of users are created with CREATE GROUP commands.
  • GRANTs are affected to each group for each database object (tables, functions, sequences, views)
  • Per-user account are created with CREATE USER commands
  • user logins are inserted into the users table
  • Users are assigned to groups with ALTER GROUP ADD user commands
schema_0_9_10_grants.1226161560.txt.gz · Last modified: 2008/11/08 17:26 by daniel