Re: HELP: Product user profile error

In article <37756_at_oasys.dt.navy.mil>, owens_at_oasys.dt.navy.mil (Jacqueline Owens) writes:
|> Hello netland,
|>
|> Can someone please help? We are getting the following error when we
|> run SQL*PLUS:
|>
|> WARNING: Product user profile information not loaded!
|> Error in disabling roles in product user profile.
|>
|> I assumed that this is the same user profile used when you create
|> user accounts. If this is so, we used the default (unlimited?).
|> Eventually, we are going to change this.

It is a facility used by SQL*plus (amongst others) for disabling particular commands for particular users.

As user system, you need to run the script pupbld.sql. Under Unix this is in $ORACLE_HOME/sqlplus/admin....

|>
|> Question:
|>
|> 1) Why is SQL*PLUS not loading this information?
|>
|> 2) Why is SQL*PLUS trying to disable the roles?
|>
|> Forgive me if these are stupid questions, but I am new to ORACLE7.
|>
|> Background info:
|>
|> PLATFORM - VAX /VMS (5.5-2)
|> RDBMS - 7.0.12
|> SQL*PLUS - 3.1
|>
|> Any help would be appreciated.
|>
|> Jackie O.
 

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com        Phone: +44 224 242637