Authorization Issue on TEXT_CONFIGURATION_CREATE while updating the .hdbtexrule in SAP HANA

[former_member346555]

Hi All,

I am trying to replace Hana Text Analysis Rule file. I am using TEXT_CONFIGURATION_CREATE procedure.

https://help.sap.com/viewer/62e301bb1872437cbb2a8c4209f74a65/2.0.03/en-US/5c759400d5ce41d2a8158da0db...

While i am executing this through SQL i am getting

" Could not execute 'CALL TEXT_CONFIGURATION_CREATE('xxx', 'TestHana.HDBModule::Word_Rules', 'hdbtextrule', '#group ...' in 183 ms 114 µs . SAP DBTech JDBC: [258]: insufficient privilege: current user abcd has no privilege on 'xxx' to create or replace a text configuration "

Although when i am executing this SQL statement via HANA Cockpit SYSTEM Console it is executed successfully.

Am i missing some authorizations on ABC user???

[HakanHaslaman]

In such a case, I would recommend to make an authorization trace.

Please enable authorization trace according to

https://wiki.scn.sap.com/wiki/display/SAPHANA/Troubleshooting+SAP+HANA+Privileges+and+Authorisations

++++++++++++++++++++++++++

1. Enable the HANA authorization trace:

alter system alter configuration ('indexserver.ini','SYSTEM') SET ('trace','authorization')='info' with reconfigure

2. Reproduce the issue.

3. Turn off the trace:

alter system alter configuration ('indexserver.ini','SYSTEM') UNSET ('trace','authorization')with reconfigure

After that please collect the indexserver trace files from HANA Studio during the time when you reproduced the error and check the content related to authorization errors.