AnsweredAssumed Answered

How do you truncate table DIVDB without DBO and ddladmin permissions?

Question asked by hrkim on Apr 9, 2019
Latest reply on Apr 10, 2019 by Michael_Pirson

Being a bank, we are only allowed to have DB reader and writer permissions on our SQL db in the higher environments.  This is why when I run the DB maintenance workflow for the first time, the DB Unload portion fails with:

 

20190409/103027.720 - U00037118 Starting with OFS cleanup for client ALL
20190409/103027.720 - U00037119 Finished OFS cleanup with status: OK
20190409/103027.720 - U00037029 According to [REORG], MAX_DEADLOCK='100' in the INI file, DEADLOCK situations will be restarted up to '100' times.
20190409/103027.736 - U00037111 Starting reorganization for client: 'ALL'
20190409/103027.767 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 11161d0 DB-HDBC: 11162b0
20190409/103027.767 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
20190409/103027.767 - U00003592 UCUDB - Status: '42000' Native error: '1088' Msg: 'Cannot find the object "DIVDB" because it does not exist or you do not have permissions.'
20190409/103027.767 - U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: 'truncate table DIVDB'
20190409/103027.767 - U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '42000', 'Cannot find the object "DIVDB" because it does not exist or you do not have permissions.'
20190409/103027.767 - U00037178 Error occurred in SQL-truncate of table DIVDB.
20190409/103027.767 - U00037107 Error during reorganization of table 'OH'. Program exits with error.
20190409/103027.767 - U00037022 ABORTING due to error.

Does anyone know how to truncate a table without DBO and ddladmin permissions?

 

Any advice/help anyone can provide, I will very much appreciate.  Thanks!

Outcomes