Search This Blog


Oracle SQL*Plus rarely uses options

Oracle SQL*Plus utility, sqlplus, has 1 options, called -R which introduce 3 level of restricted access inside SQL*Plus.

For example, "sqlplus -R3" will restrict the connection so that it cannot use:
  1. EDIT to edit current SQL command
  2. GET to read SQL script
  3. HOST to run OS command
  4. ! to run OS command
  5. @@ or @ to run a SQL script
  6. SAVE to save SQL statement
  7. SPOOL to save the output
  8. STORE

No comments: