View Single Post
  #5 (permalink)  
Old September 29th, 2008, 21:42
Joe Patton Joe Patton is offline
Junior Member
 
Join Date: Jun 2008
Posts: 7
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 1
Thanked 1 Time in 1 Post
Rep Power: 0
Joe Patton is on a distinguished road
Re: DB Security Question

Thanks for the answers, Alan and Chris. I took a look at the trigger code example in the file that you specified and was able to get the proper access for the user in question. This account can only select from glogowner.gl_login_history. The user in question has execute privileges on the GLOGOWNER.VPD package so that the SET_USER procedure can be executed within the logon trigger. Are there any security concerns regarding execute priv's against the VPD package?
Reply With Quote