| Restrict Connection to Data Base Whit Other Application [message #180917] |
Wed, 05 July 2006 16:27  |
henryhrcr
Messages: 6
Registered: July 2006
|
Junior Member |
|
|
Hello there.
I need to implement security to restrict to the users connect to the database whith others applications (that not are the company application).
For example. The users of the Financial System, implemented in Developer Forms 6i, cannot connect to the database using for example, SQL*Plus or Toad Application.
I know there are some triggers : Pre-Logon, On-Logon and Post-Logon, but i do not know how use them and how to implement this.
Have you implemented something similar ?
Thank you for your help.
Bye.
|
|
|
|
|
|
| Re: Restrict Connection to Data Base Whit Other Application [message #181066 is a reply to message #180933] |
Thu, 06 July 2006 10:11  |
henryhrcr
Messages: 6
Registered: July 2006
|
Junior Member |
|
|
Thank you for your help.
Let me explain, maybe i did not explain good.
Really, i need restrict access to bd to other application different 'MY-APPLICATION' no matter what type of application.
Really, a need to identify my application and in the post-logon trigger.I need to verify if the application is 'My-Application', something like this :
In post logon trigger in data base :
Select Module
Into vcModule
From v$Session
Where audsid = mySession
If vcModule <> 'My-Application' Then
Restrinct Connection ...
End If;
The problem is ... i can not identify my application. I am using Developper 6i ... and when my application start, do not set the v$session.module or v$session.program.
I set using dbms_application_info.set_module in post-logon of the principal form (window), when the program begin, but the problem is the post-logon trigger in data base, where i check the restriction, begins before the post-logon trigger in the form (application), so when i check the application name, it is not set yet.
I need to identify my application using a name for it, for example, 'MY-APPLICATION', but before post-logon trigger in data base was executed.
Thank for your help.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
