Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Security for sqlplus--
In article <32C01FD6.3ABA_at_dsi.bc.ca>, Brian Spears
<brian_spears_at_dsi.bc.ca> writes
>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
Look into the use of the PRODUCT_USER_PROFILE table. This allows you to
limit access to certain commands in SQL*Plus. I can't remember where
this is documented, but try the SQL*Plus reference manual
-- Jim SmithReceived on Thu Dec 26 1996 - 00:00:00 CST