Jason Tesser wrote:
> ok so what would prevent users from using SQL tools to connect to the database
> and browse data?
#5:
"REVOKE SELECT on salaries from the public and GRANT select on
v_salaries to the public."
Since CURRENT_USER is set at connection time, and since they will only
be able to SELECT from the views, they can only see what they're
supposed to see...
Mike Mascari
mascarm@mascari.com