does oracle 8i provides column-level security?

Hi,
As I know that oracle 8i vpd can provide row-level security,but I want to use
oracle 8i's vpd to mask columns.how can i do it?
thanks.

why not just create a view not including the columns you want?

Quote:

---

Originally Posted by davey23uk

why not just create a view not including the columns you want?

---

Because the columns are available to some users but not to the others,and
I can't modify the application.

Quote:

---

Originally Posted by smartcobra

Because the columns are available to some users but not to the others,and
I can't modify the application.

---

It looks like you are running out of options, two questions to better picture your situation:
Is the application fully qualifying table names?
Is the application accessing tables directly or thru synonyms?

Quote:

---

Originally Posted by PAVB

It looks like you are running out of options, two questions to better picture your situation:
Is the application fully qualifying table names?
Is the application accessing tables directly or thru synonyms?

---

yes the application is fully qualifying table names and accessing tables through synonyms.

As a newbie I should probably stay out of this discussion...but maybe I'll learn something.

Seems to me if app is fully qualifying table names (ie: table_owner.table_name) then it's not using synonyms. I suppose it could be fully qualifying synonyms (ie: synonym_owner.synonym_name) but that makes little sense.

If each user of app has own Oracle logon, and if app is NOT qualifying table names, then some users can have synonym pointing to the actual table and other users a synonym pointing to a view or views you have setup which eliminates certain columns. Have I overlooked something?

Nicely done ROPMax.