Security for sqlplus--

HI,

  Does anyone know how to limit how SQLPLUS is used. Ie. All users   have all privs to schema through an application's standard use of   ORACLE. I want to allow users to use sql*plus with select privilege   only. Can I control who can access sql*plus? If so I could create   a user with no quota and only select privs to access sql*plus. This   solution would do if I can control user access to the tool.

   If I can not control users - tool, does anyone know of another    way to save the database. I know of a 3rd party tool but I    want to avoid this if possible for the present time.

Brian Spears
DBA , Dynapro Received on Tue Dec 24 1996 - 00:00:00 CST