SQL*Plus User's Guide and Reference
Release 8.1.6

A75664-01

Library

Product

Contents

Index

Prev Up Next

Security, 4 of 4


SQLPLUS -RESTRICT

Like the Product User Profile table, the RESTRICT option allows 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 

For more information about the RESTRICT option, see the SQLPLUS -R[ESTRICT] {1|2|3} command


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index