Oracle SQL*Plus: The Definitive Guide

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.

The next few sections show you how to perform each of these tasks.

Creating the Profile Table

Oracle supplies a script named PUPBLD.SQL that creates the table, views, and synonyms shown earlier in this chapter in Figure 9.1. On Windows-based systems, the script can be found in the DBS directory, underneath the Oracle home directory. On Windows NT, the full path and filename for the script is:

C:\ORANT\DBS\PUPBLD.SQL

On Unix systems, the script will be in the SQL*Plus product’s admin directory. For example, under HP-UX, and running Oracle 7.3.3, the full path and filename for the script is:

$ORACLE_HOME/sqlplus/admin/pupbld.sql

In some instances, the SQL*Plus directory will be named plusXX instead of sqlplus. The XX in the name represents the Oracle version number, so with Oracle 7.1, the directory would be named plus71.

PUPBLD.SQL should be executed while logged in as user SYSTEM. Executing it while logged in as some other user will result in the profile table being created in the wrong schema, and may also ...