Discussion Locked

Oracle

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

6 replies

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),

http://www.ora.com/catalog/orsqplus/chapter/ch09.html

by ha_florez

This table disable this commands when you are running on SQL, you can make an Insert using Oracle Forms or another tool

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 maxwell edison

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.