| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table security question
A copy of this was sent to martinj(replace this with @)xs4all.nl (Martin
Jesterhoudt)
(if that email address didn't require changing)
On Fri, 18 Sep 1998 19:47:36 GMT, you wrote:
>On Fri, 18 Sep 1998 19:19:17 GMT, kshave_at_mbnet.mb.ca (Keith S.) wrote:
>
>> I want to give read access to the table, but only to columns 1,2 and
>>5. By granting 'SELECT' access on the table I would allow the user to
>>view all of the columns.
>
>You can create a view on column 1,2 and 5 and give 'GRANT SELECT' on
>this view. If you create a synonym for the view with the same name for
>the specific user, the user won't even be aware of the non existence
>of column 3 and 4.
>
>You can also give column rights in stead of the complete table:
>'GRANT SELECT (column1, column2, column5) ON yourtable TO ...'.
^^^^^^^^^^^^^^^^^^^^^^^^^^^
nope that syntax does not work. that works for update/insert privs but not select... the view is the answer.
>-------------------------------------------------------------------------------
>--- Martin Jesterhoudt
>--- martinj(replace this by @)xs4all.nl
>-------------------------------------------------------------------------------
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Sep 18 1998 - 14:58:09 CDT
 |
 |