Re: What does table SYSTEM.PRODUCT_PROFILE / SYSTEM.USER_PROFILE ???

Hej Stephan
Can't remeber the full story, but it's a mean to control which users can access the database with certain privileges from specified products (applications).
When sql*plus locks onto the database, it identifies itself as "sql*plus" (can be setup by environment in sql*plus) and thereby the user can have a set of privileges (select/update etc.), but in another application the user can have another set of privileges. I know there is a paper somewhere on OTN and/or oracle.com with more info. Search for "product user profile". Hopes this helps.

In article <390833B2.69C91B14_at_beusen.de>,   stephan.born_at_beusen.de wrote:
> I found the two table PRODUCT_PROFILE and USER_PROFILE
> in the system-schema of an Oracle 7.3.4.0.0 database on NT.
> What are the tables for? Where can I find information on the tables?
>
> Can you help me?

--
Bo Seiffert
Somewhere in Denmark
Even if you are on track, you will get run over if you just sit there


Sent via Deja.com http://www.deja.com/
Before you buy.