View Single Post
  #3 (permalink)  
Old September 26th, 2008, 21:51
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 reply, Chris. The following command works if I open up a SQL*Plus session:

exec vpd.set_user('DBA.ADMIN')

The account seems to lose the profile setting when the session is closed. Is there a way to permanently assign the user that I created to the 'DBA.ADMIN' profile? Thank you for the link to the tutorial. I will be trying to educate myself on VPD next week if I have the time.

Joe Patton
Reply With Quote