116 reputation
6
bio website
location Green Bay, WI
age
visits member for 2 years, 7 months
seen Mar 9 at 19:45

Not a DBA, not even close, but there is light at the end of the tunnel.


Mar
9
comment Restrict Oracle DB Login based on SQL Client being used
@wernfried This trigger worked pretty nicely. We did some changes to it to include checking the user PROFILE and instead of checking the program we check the MACHINE from where the conncection is coming from. Our Application always connects from the App Server Machine id even when User logs on to the app from their PC and that server machine id will not change (ever). So that solves the program name problem.
Mar
9
awarded  Scholar
Mar
9
accepted Restrict Oracle DB Login based on SQL Client being used
Feb
27
awarded  Student
Feb
27
comment Restrict Oracle DB Login based on SQL Client being used
Yes, I figured that is the only safe way but revoking access privilege will mean revoke privileges from the application too, which we don't want to do. I don't think the users are that smart to be changing their connection properties ;) but the question is will a BEFORE LOGON trigger with revoke command work?
Feb
27
comment Restrict Oracle DB Login based on SQL Client being used
But we know the Application client's name. Can we restrict it like if not <app_client> then... perhaps through a BEFORE LOGON trigger? We also know the Machine Name which will always be the Application server name if the user is using the Application, that can be used as well?
Feb
26
asked Restrict Oracle DB Login based on SQL Client being used
Sep
24
awarded  Autobiographer
Mar
10
awarded  Citizen Patrol
Oct
18
awarded  Supporter
Oct
1
comment How to modify an update in Oracle so it performs faster?
Yes they are and I am aware of that. But its not what I asked? SELECT NULL... is plain confusing and shouldn't be used (unless you are using a UNION).
Oct
1
comment How to modify an update in Oracle so it performs faster?
Wouldn't ..AND EXISTS (SELECT NULL.. always return false? Would this - ..AND NOT EXISTS (SELECT 1.. make more sense??
Aug
28
awarded  Teacher
Aug
27
answered Linux Error: 29: Illegal seek in LSNRCTL for Linux Version 11.2