From: MJ Santhosh <mjsanthosh@gmail.com>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org, "Richard Broersma Jr" <rabroersma@yahoo.com>
Subject: Re: i have a problem of privilages
Date: Tue, 4 Jul 2006 17:47:00 +0530
Message-ID: <224a3e7e0607040516l74256698ga54ba116863a2610@mail.gmail.com> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C906979C42@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C906979C42@venus.infics.com>
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…
>
> 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 solution
> …
>
>
>
>
>
> *Thanks & Regards*
>
> *Penchal reddy **|** Software Engineer *
>
> *Infinite Computer Solutions **|** Exciting Times…Infinite
> Possibilities... *
>
> *SEI-CMMI level 5 **| **ISO 9001:2000*
>
> *IT SERVICES **|**BPO
> *
>
> *Telecom **|** **Finance **|** **Healthcare **| **Manufacturing **|** **Energy
> & 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 information
> that is privileged, confidential or exempt from disclosure under 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 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 under
> 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.
>
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mjsanthosh@gmail.com, penchalaiahp@infics.com, rabroersma@yahoo.com
Subject: Re: i have a problem of privilages
In-Reply-To: <224a3e7e0607040516l74256698ga54ba116863a2610@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox