Re: Security for sqlplus--

create a new user (in the database) for each user. Give the new user names whatever privs you want them to have.

On Tue, 24 Dec 1996 10:24:22 -0800, Brian Spears <brian_spears_at_dsi.bc.ca> wrote:

>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 Thu Dec 26 1996 - 00:00:00 CST