Download SQL*Plus User's Guide and Reference

Transcript
Disabling Commands with SQLPLUS -RESTRICT
Disabling Commands with SQLPLUS -RESTRICT
Like the Product User Profile table, the RESTRICT option enables you to disable
certain commands that interact with the operating system. However, commands
disabled with the -RESTRICT option are disabled even when no connection to a
server exists, and remain disabled until SQL*Plus terminates.
The following table shows which commands are disabled in each restriction level.
Command
Level 1
Level 2
Level 3
EDIT
disabled
disabled
disabled
GET
disabled
HOST
disabled
disabled
disabled
SAVE
disabled
disabled
SPOOL
disabled
disabled
START
disabled
STORE
disabled
disabled
Notes:
Q
Q
Disabling HOST also disables your operating system's alias for
HOST, such as $ on Windows, and ! on UNIX.
Disabling the SQL*Plus START command will also disable the
SQL*Plus @ and @@ commands.
For more information about the RESTRICT option, see the SQLPLUS RESTRICT
Option on page 4-23.
SQL*Plus Security 10-9