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

2 comments:

  1. A nice article here, i think that people who have grown up with the idea of using computers are showing more responsibility towards writing posts that are thoughtful, do not have grammar mistakes and pertinent to the post..
    SAP HANA Training in Chennai
    SAP MM Training in chennai
    SAP Basis Training in chennai

    ReplyDelete
  2. To perform Backup and Recovery a user should need appropriate roles/authorization. this roles/authorization determines whether tasks are performed at DB/System levels.


    The following authorization are required to perform the tasks.



    http://www.sapblog.in/2019/07/sap-hana-backup-recovery-user-authorizations.html

    ReplyDelete