| 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 kshave_at_mbnet.mb.ca (Keith S.)
(if that email address didn't require changing)
On Fri, 18 Sep 1998 19:19:17 GMT, you wrote:
> I have a table with several columns in it. For example ...
>
>TABLE a
> col 1
> col 2
> col 3
> col 4
> col 5
>
> 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.
>
> Besides separating columns 3 and 4 out into a separate table and
>assigning appropriate access there, is there any way to restrict the
>access to these columns but still give read access to the rest of the
>columns?
is using a view ok with you?
create view
a_view
as
select col1, col2, col5 from a;
grant select on a_view to WhomEver;
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:41:57 CDT
 |
 |