Hi Dmitry,
Got it working
i made a small change.
On Friday 27 September 2002 00:47, you wrote:
> I think this should work:
>
> alter table mytable owner to postgres;
> grant all on my table to public;
instead of
> revoke delete on my table from public;
i did :
revoke delete on my table
I think this should work:
alter table mytable owner to postgres;
grant all on my table to public;
revoke delete on my table from public;
I hope, it helps...
Dima
Rajesh Kumar Mallah. wrote:
> Hi ,
>
> I have a created a database and a table in it,
>
> I want to prevent "DELETES" on the table
Hi Robert,
I will be obliged to receive the "real" code , if its
feasible for you. I am not used RULEs before.
regds
mallah.
On Friday 27 September 2002 00:39, Robert Treat wrote:
> In psuedo-code : create rule on mytable on delete return null
>
> Robert Treat
>
> On Thu, 2002-09-26 at 15:00,
Hi Dima,
I currently have only one user in the system
its me and superuser postgres.
every thing belongs to me currently.
and the programs connect as me.
if make transfer the database ownership to postgres
will all the tables also get transfered to him?
it that case all programs will stop
In psuedo-code : create rule on mytable on delete return null
Robert Treat
On Thu, 2002-09-26 at 15:00, Rajesh Kumar Mallah. wrote:
> Hi ,
>
> I have a created a database and a table in it,
>
> I want to prevent "DELETES" on the table in this
> database by everyone except superuser postgres.
>
> I have a created a database and a table in it,
>
> I want to prevent "DELETES" on the table in this
> database by everyone except superuser postgres.
> even by me (the creator of this database and table)
make superuser the database owner & grant the rights needed to the users
---
Hi ,
I have a created a database and a table in it,
I want to prevent "DELETES" on the table in this
database by everyone except superuser postgres.
even by me (the creator of this database and table)
I have tried in many ways (ALTER TABLE REVOKE DELETE .. etc etc)
but i always end up with h
