From ganapatiram@symphonydata.com Thu Feb 17 11:19:19 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 355D18B9CE7 for ; Thu, 17 Feb 2005 11:19:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62615-03 for ; Thu, 17 Feb 2005 11:19:07 +0000 (GMT) Received: from rs7k.tempdomainname.com (rs7k.tempdomainname.com [198.173.255.221]) by svr1.postgresql.org (Postfix) with ESMTP id 52FAD8B9B41 for ; Thu, 17 Feb 2005 11:19:08 +0000 (GMT) Received: from rram ([220.227.243.252]) (authenticated bits=0) by rs7k.tempdomainname.com (8.13.1/8.12.6) with ESMTP id j1HBJ4jB077008 for ; Thu, 17 Feb 2005 11:19:06 GMT (envelope-from ganapatiram@symphonydata.com) Message-ID: <000801c514e1$f6d6da40$8c0aa8c0@rram> Reply-To: "ganapatiram" From: "ganapatiram" To: Subject: Access Permissions to Users Date: Thu, 17 Feb 2005 16:45:15 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C51510.0E9A7230" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/183 X-Sequence-Number: 16351 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C51510.0E9A7230 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Experts, 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. Thanks and Regards Ram ------=_NextPart_000_0005_01C51510.0E9A7230 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Experts,
 
          I am = using=20 Postgresql 8.0 windows version. I am using this in the server as well as = clients=20 with the same access permissions to users as i am not aware how to = set-up the=20 access permissions for other users seperating super user.
 
       =20     If i want to give only view permissions to a set of = users,=20 how can i do that?
 
          &nbs= p; If=20 i want to give only insert & view permissions to a set of = users, how=20 can i do that? and on...
 
 
Please let me know how can i set access = permissions.
 
Thanks and Regards
Ram
------=_NextPart_000_0005_01C51510.0E9A7230-- From desoi@pgedit.com Mon Feb 21 06:28:13 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A2A168B9E41 for ; Mon, 21 Feb 2005 06:28:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31533-09 for ; Mon, 21 Feb 2005 06:28:10 +0000 (GMT) Received: from a2s1.a2webhosting.com (host-180.a2webhosting.com [69.39.89.180]) by svr1.postgresql.org (Postfix) with ESMTP id 06ABC8B9E10 for ; Mon, 21 Feb 2005 06:28:10 +0000 (GMT) Received: from user-112162m.dsl.mindspring.com ([66.32.152.86] helo=[192.168.1.10]) by a2s1.a2webhosting.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.44) id 1D373B-0003cQ-CM; Mon, 21 Feb 2005 01:28:09 -0500 In-Reply-To: <000801c514e1$f6d6da40$8c0aa8c0@rram> References: <000801c514e1$f6d6da40$8c0aa8c0@rram> Mime-Version: 1.0 (Apple Message framework v619) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: Content-Transfer-Encoding: quoted-printable Cc: From: John DeSoi Subject: Re: Access Permissions to Users Date: Mon, 21 Feb 2005 01:27:59 -0500 To: "ganapatiram" X-Mailer: Apple Mail (2.619) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s1.a2webhosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.011 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/184 X-Sequence-Number: 16352 On Feb 17, 2005, at 6:15 AM, ganapatiram wrote: > > =A0=A0=A0=A0=A0=A0=A0=A0=A0 I am using Postgresql 8.0 windows version. = I am using this=20 > in the server as well as clients with the same access permissions to=20= > users as i am not aware how to set-up the access permissions for other=20= > users seperating super user. > =A0 > =A0=A0=A0 =A0=A0=A0 =A0=A0=A0 If i want to give only view permissions = to a set of users,=20 > how can i do that? > =A0 > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0If i want to give only insert & = view=A0permissions to a set=20 > of users, how can i do that? and on... > =A0 > =A0 > 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=20 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