From: | postgres(at)taifun(dot)interface-business(dot)de |
---|---|
To: | Balazs Gyetvai <balazs(at)securities(dot)hu> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | RE: [GENERAL] Grant problems |
Date: | 2000-02-07 10:56:04 |
Message-ID: | XFMail.000207115604.postgres@taifun.interface-business.de> |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hallo,
> I like to create a user who can do the followings on a table: select,
> insert, update
> But he can't delete!
> I tried this: grant INSERT, SELECT, UPDATE on table_name to testuser;
> After this the test user can delete from the table_name table without any
> problems. The testuser is not a superuser.
GRANT UPDATE and GRANT DELETE are commands with the same result in the
system tables: They modify both the "w" component in the relacl attribute
of pg_class! As result of this undocumented design bug you can't deny
UPDATE's but allow DELETE's and vice versa.
Gerald Fiedler
From | Date | Subject | |
---|---|---|---|
Next Message | Sevo Stille | 2000-02-07 12:27:43 | Re: [GENERAL] using ID as a key |
Previous Message | Matthias Zehnder | 2000-02-07 10:38:47 | limits for a text field |