Re: Prevent somebody logging in with SQL/Plus?

We can prevent using some or all sql*plus and sql command from sql*plus by using PRODUCT_USER_PROFILE table which has to be created in system account. USe pupbld.sql to create this table and grant necessary permissions to other users on this table. You can prevent the user to do modifications to database from sql*plus by inserting rows into PRODUCT_USER_PROFILE. suppose you want to restrict user 'jones' from inserting,updating, deleting in the databse from sql*plus insert the followings in the columns of PRODUCT_USER_PROFILE.

PRODUCT USERID ATTRIBUT SCOPE NUMERICVALUE CHARVALUE DATE VALUE

SQL*Plus  JONES  INSERT    null   null       DISABLED    null
SQL*Plus  JONES  UPDATE    null   null       DISABLED    null
SQL*Plus  JONES  DELETE    null   null       DISABLED    null

Hope this will solve your problem.

posani suresh

posani_at_hotmail.com

In article <34f13917.259361810_at_firewall.celltech>,   jpetts_at_celltech.co.uk (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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Feb 23 1998 - 00:00:00 CST