Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata