| |
 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Using PUPBLD
pupbld.sql can be used for more than
stopping those irritating "PRODUCT PROFILE TABLE NOT LOADED"
messages from occurring when you log on to SQL*PLUS. pupbld.sql
creates a product profile table that is read by SQL*PLUS when users
log on to the product.
Front-end applications can be designed to
prevent users from updating data incorrectly. What happens if the
user logs on to the database using their database account and
password using SQL*PLUS? The application code is not available to
prevent them from making incorrect or unwarranted changes to the
database data. Administrators can prevent this from happening by
inserting rows into the product profile table to disable a SQL*PLUS
user's ability to execute:
-
SQL*PLUS commands - COPY, EDIT, EXECUTE, EXIT,
GET, HOST (or your operating system's alias for HOST, such as $on
VMS, and ! on UNIX),QUIT, PASSWORD, RUN, SAVE, SET, SPOOL, START
-
SQL statements ALTER, ANALYZE, AUDIT, CONNECT,
CREATE, DELETE, DROP, GRANT, INSERT, LOCK, NOAUDIT, RENAME, REVOKE,
SELECT, SET ROLE, SET TRANSACTION, TRUNCATE, UPDATE
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
