Document Type | Technical Information
Category | Monitoring/Inspection
Applicable Product Version | 7FS02
Document Number | TMOTI016
Overview
Unlike tbsql, Tibero Studio requires additional permissions to use SQL Trace because the method of retrieving Trace information differs.
The permissions required to use SQL Trace in Tibero Studio are as follows.
- CONNECT
- RESOURCE
- SELECT ON SYS.V$SESSION
- SELECT ON SYS.V$PARAMETERS
- CREATE ANY DIRECTORY
- CREATE ANY LIBRARY
- READ ON DIRECTORY USER_PATH
- WRITE ON DIRECTORY USER_PATH
Example
Create user test identified by 'test'; create table test.t1(c1 number); insert into test.t1 select level from dual connect by level <=10000;
Method
If Permissions Are Missing
Below are the permissions that must be granted to the user (TEST) to use the SQL Trace feature in Tibero Studio.
- GRANT CONNECT TO TEST;
Check Permissions
SQL> select GRANTEE, OWNER, TABLE_NAME, TYPE, PRIVILEGE from user_tab_privs; 0 row selected. SQL> select * from user_role_privs; GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE -------------------- -------------------- ------------ ------------ TEST CONNECT NO YES 1 row selected. SQL> select * from user_sys_privs; 0 row selected.
When Permissions Are Granted
The following commands grant the necessary permissions to the user (TEST) to use the SQL Trace feature in Tibero Studio.
- GRANT RESOURCE TO TEST;
- GRANT SELECT ON SYS.V$SESSION TO TEST;
- GRANT SELECT ON SYS.V$PARAMETERS TO TEST;
- GRANT CREATE ANY DIRECTORY TO TEST;
- GRANT CREATE ANY LIBRARY TO TEST;
- GRANT READ ON DIRECTORY USER_PATH TO TEST;
- GRANT WRITE ON DIRECTORY USER_PATH TO TEST;
Check Permissions
SQL> select GRANTEE, OWNER, TABLE_NAME, TYPE, PRIVILEGE from user_tab_privs; GRANTEE OWNER TABLE_NAME TYPE PRIVILEGE -------------------- -------------------- ------------------------------ ----------------------- ------------------------------ TEST SYS V$SESSION VIEW SELECT TEST SYS V$PARAMETERS VIEW SELECT TEST SYS USER_PATH DIRECTORY READ TEST SYS USER_PATH DIRECTORY WRITE 4 rows selected. SQL> select * from user_role_privs; GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE -------------------- -------------------- ------------ ------------ TEST CONNECT NO YES TEST RESOURCE NO YES 2 rows selected. SQL> select * from user_sys_privs; USERNAME PRIVILEGE ADMIN_OPTION -------------------- ------------------------------ ------------ TEST CREATE ANY DIRECTORY NO TEST CREATE ANY LIBRARY NO 2 rows selected.
