A security problem (newbie)
От | Paulo da Silva |
---|---|
Тема | A security problem (newbie) |
Дата | |
Msg-id | 36DC5E86.DCEC3246@esoterica.pt обсуждение исходный текст |
Список | pgsql-general |
Hello, I'm sorry if this is the 2nd post. I'm not sure if it was sent the 1st time. I need to grant access to some records of ts table to user psergio. I created 2 views. psergio should be allowed to use select only on one of them. But I removed access to the whole table. So, although I grant access to va, it is denied because the ts table is not acessible! How can I turn around this? TIA -- Paulo (pdasilva@esoterica.pt)CREATE TABLE ts ( dep text, descr text ); INSERT INTO ts VALUES ('A','aaaaaa'); INSERT INTO ts VALUES ('B','bbbbbb'); INSERT INTO ts VALUES ('B','xxxxxx'); INSERT INTO ts VALUES ('A','yyyyyy'); create view va as select * from ts where dep='A'; create view vb as select * from ts where dep='B'; revoke all on ts from psergio; revoke all on va from psergio; revoke all on vb from psergio; grant select on va to psergio; select * from va; -- Denied because ts is not acessible!!! select * from vb; drop table ts; drop view va; drop view vb;
В списке pgsql-general по дате отправления: