Re: Help: How do you restrict user from using sql-plus?

Take SQL*Plus off their machines. <g>

And tell them if they are found connecting with it again they will be escorted to the door for wilfully disobeying a company directive.

But I would also use a LOGON trigger to check what application is being used to log on ... you can find it in V_$SESSION and then kill their sessions.

Finally, though, you should seriously consider the fact that if they can do something they shouldn't in SQL*Plus it means you have not set up a decent security environment. Get someone to evaluate what you have done and suggest fixes. Remember they can do just as much damage with TOAD, or SQL Navigator or Access, or SQL Worksheet, or any number of products. So just disabling one interface product is not a very good solution.

Daniel Morgan

Mike F wrote:

> We need to make some of our user only connect to the database through
> forms, or JDBC, but not through sqlplus, is there any way of doing that?
>
> Thanks
>
>
>
> --
> Sent by dbadba62 from hotmail within area com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Feb 14 2002 - 12:34:56 CST