2280915 - CREATE procedure gives error "258 - insufficient privilege: Not authorized error".

• When trying to CREATE a procedure in HANA Studio it fails with errors:

258 - insufficient privilege: Not authorized error.

SAP DBTech JDBC: [411]: invalid table type: Cannot find table type <TableName>: line 4 col 30 (at pos 134)

• After running an authorisation trace you can see the following in the trace file: 

[6725]{60031}[26/2071944] 2016-02-17 10:38:23.990675 e REPOSITORY       activator.cpp(01129) : 
activateObjectsInternalFast2: ActivationID 237, activation phase: Runtime sqlproc-runtime reported an error. Session error: No error(0)

Check results with severity "error":

(ERROR, error code: 8000034, error message: HRF Plugin: 26 Technical error occurred - InternalError: 
dberror(Connection.prepareStatement): 258 - insufficient privilege: Not authorized, object: 
{tenant: , package: bat, name: Aggregation, suffix: hprruleservice}, location: , time stamp: 2016-02-17,10:38:23.990, 

Repository: Activation failed for at least one object;source code move failed

exception throw location:

1: 0x00007fb95d979467 in repo::RepoException::RepoException(int, ltt_adp::basic_string<char, ltt::char_traits<char>, 
ltt::integral_constant<bool, true> > const&, char const*, int)+0x33 at repoexception.cpp:31 (libhdbrepocore.so)

2: 0x00007fb95d979549 in repo::GenerateError::GenerateError(int, ltt_adp::basic_string<char, ltt::char_traits<char>, 
ltt::integral_constant<bool, true> > const&, char const*, int)+0x5 at repoexception.cpp:56 (libhdbrepocore.so)

grant select, schema, SYS_REPO, select privilege, , KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem