To use Toad, certain privileges are required both in an Oracle database and in your Windows environment.
To use Toad, certain privileges are required both in an Oracle database and in your Windows environment.
Some Toad features require special Oracle privileges. This topic lists required privileges per Toad Edition.
| Window | Privileges |
|---|---|
| Audit SQL/Sys Privs |
To audit occurrences of a SQL statement, you must have the AUDIT SYSTEM privilege. To audit operations on a schema object, the object you choose for auditing must be in your own schema or you must have AUDIT ANY system privilege. In addition, if the object you choose for auditing is a directory object, even if you created it, then you must have AUDIT ANY system privilege. |
| Current Schema Toolbar | ALTER SESSION system privilege. |
| DBMS Debugger | DEBUG CONNECT SESSION privilege. |
| Window | Privileges |
|---|---|
| Alert Log Viewer | The user account must have the EXECUTE privilege on Oracle's UTL_File package. (The SYS schema has this privilege by default.) |
| Analyze All Objects | SELECT privileges on the CHAINED_ROWS table to view chained rows. |
| DBMS_Flashback | EXECUTE privileges for DBMS_FLASHBACK. |
| Index Monitoring | To see another user’s indexes you must have access to the SYS.OB$, SYS.IND$, SYS.USERS$ and SYS.OBJECT_USAGE views and the ALTER ANY INDEX privilege. |
| Instance Manager |
SYSDBA or SYSOPER privileges to shut down or alter the status of a database. |
| LogMiner | EXECUTE privileges on DBMS_LOGMNR and DBMS_LOGMNR_D. |
| Toad Space Manager | The Toad schema must have the privileges to create and alter jobs, create and drop its own tables and procedures, and must have SELECT access on: DBA_TABLESPACES, DBA_DATA_FILES, DBA_FREE_SPACE, and V_$FILESTAT. |
In order to install and run Toad for Oracle, make a connection, and do basic operations, you must have the following privileges:
|
Operating System |
Requirements |
|---|---|
|
Windows non-Server Windows Server |
|
|
Note: Other functionality in Toad may require additional privileges. | |
Toad can connect to one or more databases. You can create, store, change, and organize these connections all from one convenient location.