|Lesson 2||The product profile explained|
|Objective||Explain how the product profile works.|
DELETEcommand outside of the boundaries of the application. The product profile gives you the ability to limit access specifically to some of the capabilities available through SQL*Plus.
SYSTEMschema. Note: This table used to be called PRODUCT_USER_PROFILE, and a synonym by that name is created when the table is created for compatibility.
PRODUCT-This column contains the value
USER_ID-This column contains the user ID that will be affected by the limitation.
ATTRIBUTE-This column can contain either the name of a particular command that will be disabled or the keyword
ROLES, which indicates that a role is to be disabled.
CHAR_VALUE-This column contains either the keyword
DISABLEDfor a command or the name of a role.
INSERTstatements that insert data into these columns. Because the table is owned by
SYSTEM, you should be logged on as
SYSTEMwhen you execute these statements.