 column level VPD [message #187329] |
Sat, 12 August 2006 04:13  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
