Unexpected 'insufficient privileges' error for CENTRAL role

[ericvaandering]

Original Savannah ticket 102274 reported by wildish on Fri Aug 16 11:16:46 2013.

Hello,

the PHEDEX_CENTRAL_DEBUG role gets an "insufficient privileges" error when trying to update t_dps_dataset, despite having UPDATE privilege on all tables including t_dps_dataset. Example:

+verbatim+ > echo "update t_dps_dataset set is_open = 'y' where name = 'PhEDEx_Debug/LoadTest07Source/IN_TIFR';" | sqlplus -S $(PHEDEX/Utilities/OracleConnectId -db /data/DBAccessInfo/DBParam:Debug/CENTRAL) update t_dps_dataset set is_open = 'y' where name = '/PhEDEx_Debug/LoadTest07Source/IN_TIFR' * ERROR at line 1: ORA-01031: insufficient privileges -verbatim-

+verbatim+

SQL> select * from role_tab_privs where role='PHEDEX_CENTRAL_DEBUG' and table_name='T_DPS_DATASET';

ROLE OWNER TABLE_NAME COLUMN_NAME PRIVILEGE GRA

---

PHEDEX_CENTRAL_DEBUG CMS_TRANSFERMGMT_SC T_DPS_DATASET FLASHBACK NO PHEDEX_CENTRAL_DEBUG CMS_TRANSFERMGMT_SC T_DPS_DATASET UPDATE NO PHEDEX_CENTRAL_DEBUG CMS_TRANSFERMGMT_SC T_DPS_DATASET DELETE NO PHEDEX_CENTRAL_DEBUG CMS_TRANSFERMGMT_SC T_DPS_DATASET INSERT NO PHEDEX_CENTRAL_DEBUG CMS_TRANSFERMGMT_SC T_DPS_DATASET SELECT NO -verbatim-

Cheers Nicolo'

[nikmagini]

Hi,

might be a false alert - maybe we forgot to set the proper role before trying the update. To be checked again.

Cheers N.

[nikmagini]

Probably caused by failing to set the proper role before executing the SQL. Closing.