Re: Column level security ?

Hi, Ken,

 You might want to try the following GRANT statements:

 GRANT insert (col1, col2, ...) on table1 to user_name; or GRANT update (col1, clo2, ...) on table1 to user_name; or GRANT select (.....) on table1 to user_name;

 Hope this helps.

Xuening Sun
--
Ken Sproule (kenmn_at_tds.net) wrote:
: As always, I would like to thank in advance those who help.

: I assume in Oracle you can set permissions on an individual
: column.

: Does anyone know how I can restrict user access at the Column
: level?

: Thanks,

: Ken Sproule
: kenmn_at_tds.net

: Ken Sproule
: kenmn_at_tds.net

-- Received on Wed Aug 18 1999 - 08:30:56 CDT