Re: PRODUCT_USER_PROFILE, does it work?

Hello all;

In my environment (Digital unix V3.0, Oracle 7.1.4) The product user profile works as advertised. The docs are in the sql*plus user's guide and reference, appendix E.

In article <3psejn$u9u_at_lantana.singnet.com.sg> setiawan_at_merlion.singnet.com.sg (Eddy Setiawan) writes:

>I read in a book titled ORACLE DBA Handbook. It says that using
>PRODUCT_USER_PROFILE tables it's possible to disable certain commands and
>ROLES when user login from SQL*Plus. The commands such as CONNECT, HOST,
>UPDATE, DELETE can be disabled. Certain ROLES can also be disabled when
>login using SQL*Plus.
 

>However, I couldn't find the same information in ORACLE7 Server
>Administrator's Guide. Neither in ORACLE7 Server Application Developer's
>Guide. I tried it out in Personal Oracle7 on Windows, but it doesn't
>seems to work. What I did (using SQL*Plus v3.1) was:

David J. DeWolfe
Data Base Specialist
Office of Information Services (formerly UACN) University of Alaska
Fairbanks, Alaska 99775
<sxdjd_at_orca.alaska.edu>

"In a vicious struggle for survival, intelligence  emerges as the weapon of choice" NOVA - In search of human origins                                                                           Received on Sun May 28 1995 - 00:00:00 CEST