Oracle
Have you ever use the table, Product_User_Profile, on Oracle 7.3.3?
Do I need to use a path to make it work?
Networks
Have you ever use the table, Product_User_Profile, on Oracle 7.3.3?
Do I need to use a path to make it work?
by simonchan
The product user profile is an Oracle table, owned by the SYSTEM user, that contains a list of SQL*Plus command restrictions by user. The table may contain role restrictions as well. The name of this table used to be PRODUCT_USER_PROFILE. Now it is just PRODUCT_PROFILE, but a synonym named PRODUCT_USER_PROFILE exists to ensure backwards compatibility.
Primarily, the product user profile enables you to give end users access to SQL*Plus for reporting and ad-hoc query purposes, yet restrict them from using SQL*Plus commands such as INSERT, DELETE, etc., that might damage production data.
For more details, please go to (make sure that no space is inserted in the URL string),
by ha_florez
by ha_florez
I understand the use of that table, I insert the users and the SQL privilege on that table, i ran all the scipts, but it doesn't work.
I tought that i might need some patch or modify some database parameters.
I've already read those chapters
Thanks
by simonchan
I hoped that the following sample script will help (please make sure that no space is inserted in the URL string),
by ha_florez
Greetings,
Using the Product User Profile:
To use the product user profile, the first thing you need to do is create it. Oracle provides a script for this purpose. Once the product user profile table has been created, there are three things you need to know how to do:
Restrict a user, or group of users, from using a specific command.
Set a role so that it will be disabled for a given user or group of users when SQL*Plus first connects.
Report the restrictions currently in the profile table.
Cut and paste this link for full instructions on how to implement those steps:
http://www.oreilly.com/catalog/orsqplus/chapter/ch09.html#31803
(REMOVE SPACES from the pasted URL)
Maxwell
This discussion is closed to new replies.
Sort by Trending