Re: Product user profile error

From: Bob Blizard <rblizard_at_bb.ultranet.com>
Date: Mon, 13 Mar 1995 08:21:53 GMT
Message-ID: <rblizard.3.00129B07_at_bb.ultranet.com>


In article <3jshaq$jff_at_nic.dot.state.mn.us> <bryan.fredrick_at_pca.state.mn.us> (Bryan, 296-9371) writes:
>From: <bryan.fredrick_at_pca.state.mn.us> (Bryan, 296-9371)
>Subject: Product user profile error
>Date: 11 Mar 1995 15:58:18 GMT
 

>We are developing systems and have reached the point where we need a
>training database separate from the production database. I created
>the database, added the tablespaces, imported the data from the
>production and can connect just fine from sqlplus and sqldba. If I
>try to connect via SQLNET I get the following warning errors:
 

>WARNING: product user profile information not loaded!
>Error in disabling roles in product user profile.
 

>After this, the product seems to run just fine on the server. PC
>client apps (Powerbuilder) are hosed, though.
 

>Any sage advice would be welcome.
>TIA
I am not at my terminal, so of course I can't remember the exact script to run, but...

In your $ORACLE_HOME/sqlplus/... directory you will find a script named something like utlpupbld.sql (???). If you run that, it will create the Product User Profile tables, and your nasty and undocumented message will go away.

The Product User Profile feature allows you to tailor sqlplus so that certain user don't have access to various of the sql commands. This can be useful when you want to prohibit access to useful ones such as DROP, DELETE, TRUNCATE...

Have fun!

Bob Blizard
CMC Systems, Inc. Received on Mon Mar 13 1995 - 09:21:53 CET

Original text of this message