Re: i have a problem of privilages

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(at)infics(dot)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(dot)in(at)infics(dot)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(dot)in(at)infics(dot)com and delete this email from your records.
>

--