Collections:
Setup Autotrace for a User Account in Oracle
How To Set Up Autotrace for a User Account in Oracle?
✍: FYIcenter.com
If an Oracle user wants to use the autotrace feature, you can use the tutorial as an example to create the required table PLAN_TABLE, the required security role PLUSTRACE, and grant the role to that user:
SQL> CONNECT HR/retneciyf SQL> @\oraclexe\app\oracle\product\10.2.0\server \RDBMS\ADMIN\UTLXPLAN.SQL Table (HR.PLAN_TABLE) created. SQL> CONNECT / AS SYSDBA SQL> @C:\oraclexe\app\oracle\product\10.2.0\server \SQLPLUS\ADMIN\PLUSTRCE.SQL SQL> drop role plustrace; Role (PLUSTRACE) dropped. SQL> create role plustrace; Role (PLUSTRACE) created. SQL> grant plustrace to dba with admin option; Grant succeeded. SQL> GRANT PLUSTRACE TO HR; Grant succeeded.
Remember that PLAN_TABLE table must be created under the user schema HR.
2020-06-08, 820👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...