on 01-11-2016 8:18 PM
Hi,
While troubleshooting this topic: , an entirely new issue has come up.
Using SQL Script to create stored procedures directly in the catalog, I have no problem doing read / write commands: Delete, update, insert, truncate, etc., all work just fine.
When activating a .HDBPROCEDURE file, I am getting error that says: "You can only create read-only procedures on this server"
What instructions can I give my security team to fix this? My company is new with Hana and we do not have an experienced security team. Specific instructions on how I can make .HDBPROCEDURE files to write commands would be very helpful.
Thanks,
Jeff
You need create any access on that schema where you are trying to create the procedure. If you want insert/delete in any other schema, you need access for that too..
It seems you are trying it in your own schema, can you check if create any privilege for your own schema ?
With this access, I was able to create Write-Enabled procedure in my own schema.
Also check this parameter ( if set )
Choose the Configuration ----> indexserver.ini ->Repository. You need a parameter named sqlscript_mode and the value should be set to UNSECURE.
For me it is in Default and I am able to create non-read-only procedure in my schema.
Cheers
Anindya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anindya,
Thanks for the response.
I do have create any in this schema.
I will check with my security team on your suggestion regarding:
Choose the Configuration ----> indexserver.ini ->Repository. You need a parameter named sqlscript_mode and the value should be set to UNSECURE.
I will let you know if this works.
Thanks!
Jeff
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.