Re: SQL*Plus in readonly mode & Performance documentation
Date: 2 Feb 93 14:01:08 GMT
Message-ID: <11564_at_prijat.cs.uofs.edu>
> 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 18510Received on Tue Feb 02 1993 - 15:01:08 CET