Re: Security

You can grant update, delete, insert (somecolumn) on sometable to someuser. But remember you can't revoke these object privileges on individual columns; revoke works on the whole table.

You can't restrict query on certain columns except by using a view. You create a view containing only those columns you wish to expose, and revoke select on that base table from general users.

Yong Huang
yhuang_at_indigopool.com

Joel Bergeron <jb_at_ms.com> wrote in message news:1Nyt5.25742$NS6.435853_at_news.globetrotter.net...
> Is it possible to restrict access to some fields?
>
> I would like that some user have no access to some fields.
>
> thanls,
>
> Joel
>
>
Received on Thu Sep 07 2000 - 12:42:11 CDT