Re: Prevent somebody logging in with SQL/Plus?

If you're only concerned about SQL*Plus, take advantage of the PRODUCT_USER_PROFILE table. Really, the bigger concern is ODBC products. The best solution I've found is to assign a default ROLE to the users which allows only SELECT on the objects. In your application code right after the connect set the user's role to a password-protected ROLE which gives them the full access rights they need.

   remove the XYZ when replying Received on Wed Feb 25 1998 - 00:00:00 CST