From: littlec1@jaguar.uofs.edu (Chris Little)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*Plus in readonly mode & Performance documentation
Message-ID: <11564@prijat.cs.uofs.edu>
Date: 2 Feb 93 14:01:08 GMT
References: <8766@laas.laas.fr> <2XqayB1w164w@cellar.org>
Sender: news@prijat.cs.uofs.edu
Reply-To: littlec1@jaguar.uofs.edu (Chris Little)
Organization: University of Scranton
Lines: 33
Nntp-Posting-Host: jaguar.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@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@JAGUAR.UOFS.EDU                      Scranton, PA 18510