Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to allow updates by programs by not by sqlplus.
Kenneth Denny wrote:
>
> Hello,
> I need to implement a way to allow users to run sqlplus for query
> purposes, but not allow them to update. At the same time I want them to
> be able to run application programs which update the database.
>
> I'm sure there is a way this can be done. Can someone tell me how?
> Please reply by email.
>
> Thanks
> Ken Denny
> email: kdenny_at_interpath.com
You can use the Product_user_profile to table to do this. The set up & use of this table is described in SqlPlus Manual. Received on Wed May 28 1997 - 00:00:00 CDT
![]() |
![]() |