One of the application administrators set foot in my office today (how dare he!) and started off a question with "In the SQL Server World....".
Apparently, in SQLServer, there is a way to say that if user Bob is trying to connect through MS-Excel, then we allow it, but if he tries to connect in some other way, then we deny it.
Does Oracle offer something similar? I haven't been able to find anything that would indicate that it does, but I thought it doesn't hurt to ask.
We have users that are supposed to access a database via a particular application only (it's called Corvu) and we don't want them getting in via SQLPlus, Access, Excel or any other method.
I suppose it could be done via a login trigger checking the program column in v$session, but it looks like this is set to "unknown" when users are connecting through corvu, so that's not going to help me.
Any other bright ideas out there?
Thanks
Steve
Apparently, in SQLServer, there is a way to say that if user Bob is trying to connect through MS-Excel, then we allow it, but if he tries to connect in some other way, then we deny it.
Does Oracle offer something similar? I haven't been able to find anything that would indicate that it does, but I thought it doesn't hurt to ask.
We have users that are supposed to access a database via a particular application only (it's called Corvu) and we don't want them getting in via SQLPlus, Access, Excel or any other method.
I suppose it could be done via a login trigger checking the program column in v$session, but it looks like this is set to "unknown" when users are connecting through corvu, so that's not going to help me.
Any other bright ideas out there?
Thanks
Steve