In addition to views, which have already been mentioned,
column level security has been around since at least 7.0.
Look at the fine manual under 'GRANT'.
Jared
On Monday 23 June 2003 04:04, Pradeep Kumar G wrote:
> Dear All,
>
> Is there any way to implement column level security in Oracle 9i
>
Are you referring to give grants based on columns. You could use ON COLUMN
syntaxt in the grant statemetnt for INSERT, REFERENCES, UPDATE.
If this is not acceptable, then other option is using views for each user
type and based on the user's priviege type. For instance, you may have a
table called
Yup. It's called "views".
On 2003.06.23 07:04, Pradeep Kumar G wrote:
Dear All,
Is there any way to implement column level security in Oracle 9i
database ?
Information on having row level security through VPD is available. But
is it possible to have column level security ?
I have seen in some site
just make a view and dont include the columns. I dont know if there is a VPD for
columns.
>
> From: "Pradeep Kumar G" <[EMAIL PROTECTED]>
> Date: 2003/06/23 Mon AM 07:04:40 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Column level security
>
>
> Dear All,
>
>
Views?
> -Original Message-
> From: Pradeep Kumar G [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 23, 2003 4:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Column level security
>
>
>
> Dear All,
>
> Is there any way to implement column level security in Oracle 9i
> datab
What about this:
Oracle Announcement:
Oracle Security Product Management has released new security alerts
today.
Please note that you must log into MetaLink at
http://metalink.oracle.com to review this document. Use MetaLink's
advanced search option to retr
