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.
Oracle supplies a script named
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:
On Unix systems, the script will be in the SQL*Plus product’s
In some instances, the SQL*Plus directory will be named
plusXX instead of
XX in the name represents the Oracle version
number, so with Oracle 7.1, the directory would be named
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 ...