Document Type | Troubleshooting
Category | Utility
Applicable Product Versions | 6FS06, 6FS07
Document Number | TUTTS010
Issue
When performing the SQLTrace function in Tibero Studio (client), users without permission receive error 17004.
This error does not directly affect the database, but it is repeatedly recorded in the SLOG, causing unnecessary log accumulation.
# slog THROW. ec=ERROR_SECU_INSUFFICIENT_PRIVILEGE(-17004) [ Permission denied. ] (csr_id:4294967295) [ddl_check_common.c:125:ddl_check_create_obj_internal] 1-15T09:47:34.549042] [DDL-110] [I] DDL execution failed (ec = -17004): CREATE OR REPLACE LIBRARY EXTPROC IS 'null'
Cause
This error occurs when the user lacks the necessary DIRECTORY and LIBRARY privileges.
Solutions
You can temporarily work around this by granting the user (DIRECTORY, LIBRARY) privileges.
- grant create any directory to username;
- grant create any library to username;
slog after granting privileges
[01-15T10:09:09.782173] [DDL-110] [I] Executing DDL: CREATE OR REPLACE DIRECTORY USER_PATH AS '/tibero_engine/tibero6/client/lib/' [01-15T10:09:09.783012] [DDL-110] [I] DDL execution succeeded [01-15T10:09:09.790488] [DDL-110] [I] Executing DDL: CREATE OR REPLACE LIBRARY EXTPROC IS '/tibero_engine/tibero6/client/lib/libtbprof.so' [01-15T10:09:09.790990] [DDL-110] [I] DDL execution succeeded .. [01-15T10:09:09.899826] [RCF-39] [I] REDO THREAD #0 CKPT updated to 2.58539/0000.0000f126 (prev 2.58474/0000.0000f10f) [01-15T10:09:09.899869] [RCF-39] [I] DB CKPT updated: 0000.0000f10f => 0000.0000f126 (open count=1) [01-15T10:09:09.906280] [DDL-110] [I] DDL execution succeeded [01-15T10:09:09.917379] [DDL-110] [I] Executing DDL: DROP LIBRARY EXTPROC [01-15T10:09:09.918410] [DDL-110] [I] DDL execution succeeded