Re: oracle label security

You can't do it with OLS. OLS is row level security and not column level.

Thanks and Regards,
Satheesh Babu.S
Bangalore.

• Original Message ----- From: "Joe Smith" <joe_dba_at_hotmail.com> To: <oracle-l_at_freelists.org> Sent: Monday, July 31, 2006 3:16 PM Subject: oracle label security

> List,
>
> With Oracle Label Security I can block access to records and columns to
> specific users. Can I allow access to a column within a record to only
> specific information? I was asked this by a "developer/manager". There
is
> a CLOB column datatype within a table. He wants to know if I can restrict
> access and/or filter to only specific elements within that column for
that
> record.
>
> Maybe an example. Say with the CLOB column of a record I have
>
> "See the dog run"
>
> can I use OLS to allow users to only see
>
> "dog run"
>
> within that column for that record?
>
> thanks.
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l