I've been tasked to ensure only certain app programs access the
database.
I'm thinking on-logon trigger, check the program field from
v$session. unfortunately v$session is for all sessions, i can't seem to
find the view that tells me only MY info during login. I only want the
sid, serial#, username and program for my just now connection to the
database.
Does this exist or am I going about this the wrong way?
We're thinking of checking those fields to make sure sql*plus, toad, etc
can't connect as a particular user(even though the password is known out in the
community).
any ideas would be greatly appreciated.
joe
|
- RE: methodology to keep only certain programs to... JOE TESTA
- RE: methodology to keep only certain progra... Mercadante, Thomas F
- RE: methodology to keep only certain progra... Shaw John-P55297
- RE: methodology to keep only certain progra... Thomas Day
- RE: methodology to keep only certain progra... Lord, David - CSG
- RE: methodology to keep only certain progra... Fink, Dan
- RE: methodology to keep only certain progra... Kirsh, Gary
- RE: methodology to keep only certain progra... Kevin Lange
- RE: methodology to keep only certain progra... Nastase, Mr. C. (Catalin)
- RE: methodology to keep only certain progra... Mercadante, Thomas F
- Re: methodology to keep only certain progra... Jared . Still