Skip site navigation (1) Skip section navigation (2)

Re: Access Permissions to Users

From: John DeSoi <desoi(at)pgedit(dot)com>
To: "ganapatiram" <ganapatiram(at)symphonydata(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Access Permissions to Users
Date: 2005-02-21 06:27:59
Message-ID: BB5C40AE-83D1-11D9-81B6-000A95B03262@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Feb 17, 2005, at 6:15 AM, ganapatiram wrote:

>
>           I am using Postgresql 8.0 windows version. I am using this 
> in the server as well as clients with the same access permissions to 
> users as i am not aware how to set-up the access permissions for other 
> users seperating super user.
>  
>             If i want to give only view permissions to a set of users, 
> how can i do that?
>  
>             If i want to give only insert & view permissions to a set 
> of users, how can i do that? and on...
>  
>  
> Please let me know how can i set access permissions.


Use CREATE GROUP to give permissions to a set of users.

http://www.postgresql.org/docs/8.0/interactive/sql-creategroup.html

The GRANT command is used to give permissions for specific operations 
to users and/or groups.

http://www.postgresql.org/docs/8.0/interactive/sql-grant.html


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


In response to

pgsql-admin by date

Next:From: IainDate: 2005-02-21 06:42:23
Subject: Re: PostgreSQL Errors...
Previous:From: Bruce MomjianDate: 2005-02-21 05:05:18
Subject: Re: Postgres crashed on invalid IP entry in pg_hba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group