From: | Bob Dusek <bobd(at)palaver(dot)net> |
---|---|
To: | Glenn Sullivan <glenn(dot)sullivan(at)nmr(dot)varian(dot)com> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] Other user access to database |
Date: | 1998-12-08 21:42:09 |
Message-ID: | Pine.LNX.3.96.981208162312.467K-100000@farout.palaver.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bryan White | 1998-12-08 21:56:19 | Re: [GENERAL] Other user access to database |
Previous Message | Chris Williams | 1998-12-08 20:41:53 | Error with table that exists but postgres says it doesn't |