View Single Post
  #4 (permalink)  
Old September 29th, 2008, 13:39
acuartero acuartero is offline
Junior Member
 
Join Date: Jul 2006
Posts: 19
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 7
Thanked 0 Times in 0 Posts
Rep Power: 0
acuartero is on a distinguished road
Re: DB Security Question

Joe,

OTM sets the VPD profile for non-application users via the use of database logon triggers. Using a logon trigger will eliminate the need to set the profile manually each time the user logs on to the database. For an example on how to do this you can take a look at the script create_logon_triggers.sql under your OTM home /glog/oracle/script8 directory.

Thanks,
Alan
Reply With Quote