You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a problem with permissions. I test this problem on new database.
I have two users (User1 and User2), one table (TEST_TABLE (PKID, NAME, AGE)). I set permission select and update(AGE) to both users. Now everything is all right, but when I revoke permission to USER2 (revoke select, update(AGE)), then USER1 has not permission to update fields (but he should have).
Example:
create table TEST_TABLE ( PKID integer, NAME varchar(10), AGE integer,
constraint TEST_PKID primary key (PKID));
commit;
insert into TEST_TABLE values (1, 'TEST', 99);
grant select, update(AGE) on TEST_TABLE to USER1, USER2;
--USER1 or USER2:
update TEST_TABLE set AGE = 1; --both can update
revoke select, update(AGE) on TEST_TABLE from USER2;
--USER1:
update TEST_TABLE set AGE = 1; --no permission to update
Now USER1 has no permission for update/write access to COLUMN TEST_TABLE.AGE
but has permission to select. If I grant update on whole TEST_TABLE then everything all right, but if I set permission on one field,
permissions are wrong.
The text was updated successfully, but these errors were encountered:
Submitted by: Tomas Beran (berant)
I have a problem with permissions. I test this problem on new database.
I have two users (User1 and User2), one table (TEST_TABLE (PKID, NAME, AGE)). I set permission select and update(AGE) to both users. Now everything is all right, but when I revoke permission to USER2 (revoke select, update(AGE)), then USER1 has not permission to update fields (but he should have).
Example:
create table TEST_TABLE ( PKID integer, NAME varchar(10), AGE integer,
constraint TEST_PKID primary key (PKID));
commit;
insert into TEST_TABLE values (1, 'TEST', 99);
grant select, update(AGE) on TEST_TABLE to USER1, USER2;
--USER1 or USER2:
update TEST_TABLE set AGE = 1; --both can update
revoke select, update(AGE) on TEST_TABLE from USER2;
--USER1:
update TEST_TABLE set AGE = 1; --no permission to update
Now USER1 has no permission for update/write access to COLUMN TEST_TABLE.AGE
but has permission to select. If I grant update on whole TEST_TABLE then everything all right, but if I set permission on one field,
permissions are wrong.
The text was updated successfully, but these errors were encountered: