View Single Post
  #2 (permalink)  
Old September 20th, 2008, 08:28
chrisplough's Avatar
chrisplough chrisplough is offline
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 864
Blog Entries: 7
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 55
Thanked 213 Times in 126 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
Re: DB Security Question

Joe,

For a quick and dirty, all-access-allowed approach, type the following after logging in as that user via sql:

Code:
exec vpd.set_user('DBA.ADMIN')
(see http://www.otmfaq.com/forums/f21/ins...rformance-513/ ([INSTRUCTIONS] Testing VPD Query Performance) for more details.)

You should now have access to all data in all tables. Ensure that you're getting results back. From there, you'll have to dig further into VPD in order to refine the access and trim back the access to just the GLOGOWNER.GL_LOGIN_HISTORY data.

See the following URL for a brief overview and sample info on VPD:
VPD

--Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Reply With Quote
The Following User Says Thank You to chrisplough For This Useful Post:
Joe Patton (September 26th, 2008)