Ed,
Column level privileges are limited to insert, update,
and references. For select you'll need to create a
view which limits the columns displayed.
GRANT <privilege> (<column>) ON <table> TO <user>;
<column> can be a comma separated list of columns
HTH,
- Anita
- "Lewis, Ed" <Ed_Lewis_at_PremierInc.com> wrote:
>
> HI,
> Is there a way to grant access on
> the column-level, version 8.0.5 and above ?
>
> Thanks.
> ed
> --
> Author: Lewis, Ed
> INET: Ed_Lewis_at_PremierInc.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Thu May 18 2000 - 14:00:45 CDT