Home » RDBMS Server » Server Administration » column level VPD
icon2.gif  column level VPD [message #187329] Sat, 12 August 2006 04:13 Go to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
is it possible to create policies for column level VPD s through forms?
i am using ORACLE 10g.i am able to create security policy in the backend.
is it necessary to have DBA privilege to create security policy in backend?
can a application user create a security policy through forms?
http://www.abduls.tk
Re: column level VPD [message #188247 is a reply to message #187329] Thu, 17 August 2006 10:20 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Sorry I don't know much about forms. I do know you can have the form look at a view instead of the table. That way the forms program only has access to the columns you provide in the view.

You usually need to be the owner of the table to create a view on it, or have system priveleges like 'create any view.'

sys / as sysdba may be an exception to that.
Previous Topic: INSERT VALUES IN PARENT TABLES WITH SQL LOADER
Next Topic: 64 bit to 32 bit
Goto Forum:
  


Current Time: Wed Dec 07 12:32:08 CST 2016

Total time taken to generate the page: 0.09510 seconds