Sql*Plus User’s Guide and Reference

9
 SQL*Plus Security
PRODUCT_USER_PROFILE Table
...................................................................................................... 9-1
Creating the PUP Table ..................................................................................................................... 9-1
PUP Table Structure........................................................................................................................... 9-2
Description and Use of PUP Columns ............................................................................................ 9-2
PUP Table Administration................................................................................................................ 9-3
Disabling SQL*Plus, SQL, and PL/SQL Commands
........................................................................ 9-3
Creating and Controlling Roles
............................................................................................................. 9-5
Disabling SET ROLE .......................................................................................................................... 9-5
Disabling User Roles.......................................................................................................................... 9-5
Disabling Commands with SQLPLUS -RESTRICT
.......................................................................... 9-6
Program Argument Security
................................................................................................................... 9-7
10
 Database Administration with SQL*Plus
Overview
................................................................................................................................................. 10-1
Introduction to Database Startup and Shutdown
........................................................................... 10-1
Database Startup ............................................................................................................................. 10-1
PDB Startup...................................................................................................................................... 10-2
Database Shutdown ........................................................................................................................ 10-2
PDB Shutdown ................................................................................................................................ 10-3
Redo Log Files
........................................................................................................................................ 10-3
ARCHIVELOG Mode ..................................................................................................................... 10-3