subject:"\[SQL\] Permissions problem on 7.4"

Re: [SQL] Permissions problem on 7.4

2003-12-01 Thread Peter Eisentraut

Michalis Kabrianis writes: > Schema | Table |Access > privileges > -+-+- > cust| clients | {admin=a*r*w*d*R*x*t*/cust,"group salesmen=r

[SQL] Permissions problem on 7.4

2003-12-01 Thread Michalis Kabrianis

Hi I hope this is the correct list to ask about a permissions problem I have. I create a schema named cust, a table named clients, and a group named salesmen. I use: REVOKE ALL ON SCHEMA cust FROM PUBLIC; GRANT USAGE ON SCHEMA cust TO GROUP salesmen; REVOKE ALL ON TABLE clients FROM PUBLIC; GRANT