Re: [GENERAL] Column Privileges: NULL instead of permission denied

2011-09-20 Thread Matthew Hawn
> From: Stephen Frost [mailto:sfr...@snowman.net] > > * Matthew Hawn (matth...@donaanacounty.org) wrote: > > I have a table with privileged data that is restricted using column > level > > permissions. I would like to have single query that returns data > from the

[GENERAL] Column Privileges: NULL instead of permission denied

2011-09-19 Thread Matthew Hawn
Steve, NULL Permission: Dave, 456 Bill, 789 Steve, 123 I have tried: Select name, case when has_column_permission('people','ssn','select') then ssn else NULL end as ssn; But I still get a permission denied. Any Ideas?