Re: New database user.

From: Graydon Mah <graydonmah_at_home.com>
Date: Sat, 21 Jul 2001 21:26:02 GMT
Message-ID: <JdA07.292924$p33.5903074@news1.sttls1.wa.home.com>

Have a look in $ORACLE_HOME/sqlplus/admin/pupbld.sql

From Unix, you can also use the find command: cd $ORACLE_HOME
find . -name pupbld.sql -print

Graydon Mah <graydonm_at_bestnet.com>
Systems Analyst
Best Consulting, Portland Branch

"Peter Shvets" <pshvets_at_powermarket.com> wrote in message news:9htmht$2m3i$1_at_news.mainstreet.net...
> Hello, folks.
>
> I run Oracle 8.1.7 on Solaris 7,8
> I created a new database user and granted it resource and connect.
> When I try to connect as this user I get following:
>
> SQL> connect MEP/MEP
> Error accessing PRODUCT_USER_PROFILE
> Warning: Product user profile information not loaded!
> You may need to run PUPBLD.SQL as SYSTEM
> Connected.
>
> But I cannot find PUPBLD.SQL file!
>
> Any suggestions?
>
> Thank you very much in advance.
>
> Peter Shvets.
>
>
Received on Sat Jul 21 2001 - 16:26:02 CDT