X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BC9849FA350 for ; Tue, 4 Jul 2006 09:17:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 88824-10 for ; Tue, 4 Jul 2006 09:17:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id E681B9FA2F3 for ; Tue, 4 Jul 2006 09:17:01 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id y2so1165301uge for ; Tue, 04 Jul 2006 05:17:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Zr9sPLbGQt3ydThkC/UK2iF+w7FombvlNopFQpbVmoQrUoJTjDkBC+krtDLFfbKsH8Ge4pUGTuAZ39IzPxFAhzCJ+0KBg4z4pm8qoeqNDvla2ZcchlkTQsgg2kAPInhCqqHV2ALnjIRqkfJKDZKAamid/eO9cuoOvbJALQp0AfI= Received: by 10.78.179.12 with SMTP id b12mr1241295huf; Tue, 04 Jul 2006 05:17:00 -0700 (PDT) Received: by 10.78.154.13 with HTTP; Tue, 4 Jul 2006 05:16:59 -0700 (PDT) Message-ID: <224a3e7e0607040516l74256698ga54ba116863a2610@mail.gmail.com> Date: Tue, 4 Jul 2006 17:47:00 +0530 From: "MJ Santhosh" To: "Penchalaiah P." Subject: Re: i have a problem of privilages Cc: pgsql-sql@postgresql.org, "Richard Broersma Jr" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11063_87251.1152015420018" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/35 X-Sequence-Number: 25609 ------=_Part_11063_87251.1152015420018 Content-Type: text/plain; charset=WINDOWS-1252; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline create a user with limited permmission and give the same to the remote users. May be that will solve your problem. ** REVOKE INSERT,UPDATE,DELETE ON welcome from PUBLIC; On 7/4/06, Penchalaiah P. wrote: > > Hi good afternoon to every one.. > > > > Now I am accessing remote database server in postgresql.. but I can see > all tables and functions in remote database server but I can > delete,update,alter and drop tables in remote database server from my loc= al > machine.. to avoid these things wt I have to do=85 > > Just they have to see my tables and structure.. and they cant do any more > operations on the tables.. to avoid this wt can I do please tell me solut= ion > =85 > > > > > > *Thanks & Regards* > > *Penchal reddy **|** Software Engineer * > > *Infinite Computer Solutions **|** Exciting Times=85Infinite > Possibilities... * > > *SEI-CMMI level 5 **| **ISO 9001:2000* > > *IT SERVICES **|**BPO > * > > *Telecom **|** **Finance **|** **Healthcare **| **Manufacturing **|** **E= nergy > & Utilities **|** **Retail & Distribution **|** **Government > * > > *Tel +91-80-5193-0000(Ext:503)**|** Fax +91-80-51930009 **|** Cell No > +91-9980012376**|**www.infics.com** * > > *Information transmitted by this e-mail is proprietary to Infinite > Computer Solutions and/ or its Customers and is intended for use only by = the > individual or entity to which it is addressed, and may contain informatio= n > that is privileged, confidential or exempt from disclosure under applicab= le > law. If you are not the intended recipient or it appears that this mail h= as > been forwarded to you without proper authority, you are notified that any > use or dissemination of this information in any manner is strictly > prohibited. In such cases, please notify us immediately at** ** > info.in@infics.com **and delete this mail from your records.* > > > Information transmitted by this e-mail is proprietary to Infinite > Computer Solutions and / or its Customers and is intended for use only by > the individual or the entity to which it is addressed, and may contain > information that is privileged, confidential or exempt from disclosure un= der > applicable law. If you are not the intended recipient or it appears that > this mail has been forwarded to you without proper authority, you are > notified that any use or dissemination of this information in any manner = is > strictly prohibited. In such cases, please notify us immediately at > info.in@infics.com and delete this email from your records. > -- ------=_Part_11063_87251.1152015420018 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
  create a user with limited permmission and give the same to the = remote users.
May be that will solve your problem.



= REVOKE INSERT,UPDATE,DELETE ON welcome from PUBLIC;

On 7/4/06, Penchalaiah P. <penchalaiahp@infics.com> wrote:

Hi good afternoon to every one..

 

Now I am accessing remote database server in postgresql.. but I can see all tables and functions in remote database server but I can delete,update,alter and drop tables in remote database server from my local machine.. to avoid these things wt I have to do=85

Just they have to see my tables and structure.. and they cant do any more operations on the tables.. to avoid this wt can I do pleas= e tell me solution =85

 

 

Thanks  &  Regards

Penchal reddy | Software Engineer           <= font color=3D"navy">

Infinite Computer Solutions | Exciting Times=85Infinite Possibilities...

SEI-CMMI level 5 | ISO 9001:2000IT SERVICES | BPO            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =         

Telecom | Finance Healthcare | Manufacturing Energy & Utilities | Retail & Distribution | Government           = ;            &n= bsp;            = ;            &n= bsp;      

Tel +91-80-5193-0000(Ext:503) | Fax  +91-80-51930009 | Cell No  +91-9980012376 | www.infics.com        &nb= sp; 

Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and/ or its Customers and is intended for use only by the individual or entity to which it is addressed,= and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or i= t appears that this mail has been forwarded to you without proper authority, = you are notified that any use or dissemination of this information in any manne= r is strictly prohibited. In such cases, please notify us immediately at<= /font>= = info.in@infics.com and delete this mail from your records.

 

Informati= on transmitted by this e-mail is proprietary to Infinite Computer Solutions= and / or its Customers and is intended for use only by the individual or t= he entity to which it is addressed, and may contain information that is pri= vileged, confidential or exempt from disclosure under applicable law. If yo= u are not the intended recipient or it appears that this mail has been forw= arded to you without proper authority, you are notified that any use or dis= semination of this information in any manner is strictly prohibited. In suc= h cases, please notify us immediately at=20 info.in@infics.com and delete thi= s email from your records.



--

------=_Part_11063_87251.1152015420018--