Re: SQL*Plus in readonly mode & Performance documentation

> Chris Little writes:
>
> >I am looking for a way to prevent certain Oracle users from accessing
> >the database using SQL*Plus, or perhaps they could use SQL*Plus, but
> >in readonly mode. Is there a way to do this?
 

> insert into product_user_profile
> ( PRODUCT ,
> USERID ,
> ATTRIBUTE ,
> CHAR_VALUE )
> values
> ('SQL*Plus',
> upper('&&1'),
> 'INSERT',
> 'DISABLED')
>;  

> The user will now be unable to do an INSERT command in SQL*Plus.

Thank you, kml_at_cellar.org, for this answer. A few other responses mentioned the product_user_profile table, however my version 6.0 DBA Guide makes no mention of it. It's not in the index, nor in the list of "catalog" tables. If anyone can direct me to some documentation on this table, I'd be very grateful.

Thank you.

--
Chris Little, Programmer/DBA                    University Computing Systems
                                                University of Scranton
  LITTLEC1_at_JAGUAR.UOFS.EDU                      Scranton, PA 18510