Re: Prevent somebody logging in with SQL/Plus?

From: Brian P. Mac Lean <brian.maclean_at_ips-sendero.com>
Date: 1998/02/23
Message-ID: <34F1D1FC.A8160105@ips-sendero.com>#1/1

See the back of the SQL*Plus Users Guide and Reference, Restricting Users' Privileges in SQL*Plus. It's all about using the Product_User_Profile table. You may not be able to prevent users from getting into SQL*Plus(?) but you can disable just about anything they try to do in it.

James Petts wrote:
>
> Hi
>
> Is it possible to prevent somebody getting access to a database with
> SQL/Plus? I'm looking for the sort of solution that will check all new
> sessions to the database and disallow connection if the program
> being used to connect is SQL/Plus. I know that the program is
> available in v$session(program) but I'm not sure about how I would
> go about terminating a session. I envisage having a table of those
> users authorised to used SQL/Plus which would be checked before
> a session would be terminated.
>
> Any help, anybody?
>
> James "I'd rather fall off Ilustrada than ride any other horse!" Petts
Received on Mon Feb 23 1998 - 00:00:00 CST