MJ Santhosh <[EMAIL PROTECTED]> schrieb:
> I am not an expert in postgres, may this work for you.
>
> REVOKE INSERT,UPDATE,DELETE ON ALL from PUBLIC;
IIRC, you cant REVOKE ... ON ALL, you need a table-name instead ALL.
But, you can create a script for all tables:
http://people.planetpostgresql
> 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
ase tell me very briefly
step by step.. then I can understand…
Please tell me if any one knows about this……..
From: MJ Santhosh
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 04, 2006 5:47
PM
To: Penchalaiah
P.
Cc: pgsql-sql@postgresql.org;
Richard Broersma Jr
Subject: Re: [SQL] i h
]
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
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. <[EMAIL PROTECTED]> wrote:
Hi good afternoon to every one..
Now I am accessing remote da
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
