Re: Help! Error when connecting to server using SQLPlus

From: <cpw_at_slip.net>
Date: 1997/06/27
Message-ID: <867428355.20662@dejanews.com>#1/1

In article <5oqh8i$dob_at_eng-ser1.erg.cuhk.edu.hk>, kkkong_at_ee.cuhk.hk (Alan Kong) wrote:
>
> Hi,
> The following messages were observed when users connected to the Oracle
> database using SQLPlus3.1 and wonder someone could help:
>
> Error accessing PRODUCT_USER_PROFILE
> Warning: Product user profile information not loaded!
> You may need to run PUPBLD.SQL as SYSTEM.
>
> The user was created using the following statement:
>
> Create user ora_user
> identified by ora_pass;
>
> No other profile was created except the default.
>

Read up on the advantages of the PRODUCT_USER_PROFILE tables. Their main function that we use it for is to control permissions for users who use applications like SQL*Plus etc.

Coburn Watson
System/OraDB Admin
cpw_at_iacnet.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Fri Jun 27 1997 - 00:00:00 CDT