Re: i have a problem of privilages

I am not an expert in postgres, may this work for you.

REVOKE INSERT,UPDATE,DELETE ON ALL from PUBLIC;

it will take the INSERT,UPDATE,DELETE permmission from all users for all
objects in the database.

If you want to give permission for a specific user on all objects

GRANT ALL on ALL to <user_name>;

Please make a backup before doing this , good for always
I am not sure is this is want you want.

On 7/4/06, Penchalaiah P. <penchalaiahp(at)infics(dot)com> wrote:
>
> I have 290 tables .. to these tables one schema is there .. that name is
> public….so I don't know how to create permission to these tables.. either I
> have to give permissions to individual table.. or I have to give permissions
> to schema or schema name… if I give permission to schema it has to
> applicable to all tables..
>
>
>
> I created one user with password… then finally I don't know how to
> allocate permission to him.. please tell me very briefly step by step.. then
> I can understand…
>
> Please tell me if any one knows about this……..
>
>
> ------------------------------
>
> *From:* MJ Santhosh [mailto:mjsanthosh(at)gmail(dot)com]
> *Sent:* Tuesday, July 04, 2006 5:47 PM
> *To:* Penchalaiah P.
> *Cc:* pgsql-sql(at)postgresql(dot)org; Richard Broersma Jr
> *Subject:* Re: [SQL] 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.
>
>
>
>
> --
> 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.
>

_________________________________________________________
it is your attitude, and not the aptitude, that determines your altitude.
_________________________________________________________