Re: *** SQL Plus Problem - Help! ***
Date: Fri, 5 Aug 1994 07:11:17 GMT
Message-ID: <dpinkusCu1vyt.KHs_at_netcom.com>
In article <Cu1Cv3.zFB_at_hawnews.watson.ibm.com> kmara_at_vnet.ibm.com (Kevin Mara) writes:
>Hello,
> Everytime we enter SQL*Plus, we get the following message:
>
> Warning: Product user information profile not loaded!
> Error in disabling roles in product user profile.
>
>What does this mean? How can I get rid of it?
Kevin,
It means that you did not run a script that creates your Product and User Profiles... which are profiles you can configure on a per-user and perproduct basis to disable certain commands (such as DROP) from certain environments/applications. We use it to make sure users don't DROP tables (or anything else for that matter) from SQL*Plus.
The script is in
$ORACLE_HOME/sqlplus/admin/pupbld.sql and is run as SYSTEM.
Cheers,
David
-- --------------------------- David Pinkus Database Systems Consultant dpinkus_at_netcom.com h 415.922.8111 w 415.396.1252 f 415.362.1052Received on Fri Aug 05 1994 - 09:11:17 CEST