Re: [GENERAL] No select permission on a table but can query it

2008-10-15 Thread Michele Petrazzo - Unipex srl
Scott Marlowe wrote: I think that this is a strange question, but: I need to revoke the select permission on a table, but I also need to leave, with a function, a user do a query on column. A real case can be that a user "test" cannot have the permissions for do a "select * from articles", but fo

[GENERAL] No select permission on a table but can query it

2008-10-15 Thread Michele Petrazzo - Unipex srl
I think that this is a strange question, but: I need to revoke the select permission on a table, but I also need to leave, with a function, a user do a query on column. A real case can be that a user "test" cannot have the permissions for do a "select * from articles", but for do a "select has_art