Tuesday, March 31, 2015

SAP DBTech JDBC: [258]: insufficient privilege

Hi All,

Error while export catalogue object fails with SAP DBTech JDBC: [258]: insufficient privilege error in SAP HANA DB.


Exact error log is:
----------------------------------------------------------------------------------
SAP DBTech JDBC: [258]: insufficient privilege: Can't export view SAPSID.0BW:BIA:SID:0SD_C03. user has no privilege on the underlying objects 
-----------------------------------------------------------------------------------

Solution: 

Login to SAP HANA Studio as the SYSTEM user
In the security area grant the user that is having the issue the system privilege EXPORT


Thanks,
Sharib