Re: revoking a column

There may be a built-in command that I don't know about, but I've always used views to accomplish this.
CREATE view foo as select <column list minus the column you don't want seen> from bar
grant select on foo to appuser;
create synonym bar for other_user.foo;

-- 
Posted from [63.83.225.245] 
via Mailgate.ORG Server - http://www.Mailgate.ORG