Re: [GENERAL] Other user access to database

Well,

You can grant specific (read, write, etc..) permissions for the tables in
your database to any legitimate user recognized by postgres (ie. users
created with the createuser command). I am unsure as to how to grant
specific permissions on an entire database.

to see how to grant/revoke table premissions:

database_prompt=> \h grant
Command: grant
Description: grant access control to a user or group
Syntax:
grant <privilege[,privilege,...]> on <rel1>[,...<reln>] to
[public | group <group> | <username>]
privilege is {ALL | SELECT | INSERT | UPDATE | DELETE | RULE}

database_prompt=> \h revoke
Command: revoke
Description: revoke access control from a user or group
Syntax:
revoke <privilege[,privilege,...]> on <rel1>[,...<reln>] from
[public | group <group> | <username>]
privilege is {ALL | SELECT | INSERT | UPDATE | DELETE | RULE}

Hope this helps,

Bob

On Tue, 8 Dec 1998, Glenn Sullivan wrote:

> Date: Tue, 08 Dec 1998 11:55:18 -0700
> From: Glenn Sullivan <glenn(dot)sullivan(at)nmr(dot)varian(dot)com>
> To: pgsql-general(at)hub(dot)org
> Subject: [GENERAL] Other user access to database
>
> Now that I have a database functional, I need to allow other users
> to have access. Using createuser I can give other users access to
> the postmaster, but I need to give them access to my database as well.
>
> Could someone enlighten me.
>
> Glenn
>
>