From: MJ Santhosh <mjsanthosh@gmail.com>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: i have a problem of privilages
Date: Tue, 4 Jul 2006 18:01:35 +0530
Message-ID: <224a3e7e0607040531t33821d87t7d21920637417bf5@mail.gmail.com> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C906979FCA@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C906979FCA@venus.infics.com>
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@infics.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@gmail.com]
> *Sent:* Tuesday, July 04, 2006 5:47 PM
> *To:* Penchalaiah P.
> *Cc:* pgsql-sql@postgresql.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@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.
>
>
>
>
> --
> 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.
>
_________________________________________________________
it is your attitude, and not the aptitude, that determines your altitude.
_________________________________________________________
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
Subject: Re: i have a problem of privilages
In-Reply-To: <224a3e7e0607040531t33821d87t7d21920637417bf5@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