HANA CLOUND: Error: (dberror) [389]: invalid role name

[Claytoncbj]

Hi !

Could you help me with this error?

Thank you!

Could not execute 'grant "GENERICROLEFOROO" to UFS WITH ADMIN OPTION'

Error: (dberror) [389]: invalid role name: GENERICROLEFOROO: line 9 col 6 (at pos 6)

[ghoshsayantan3 · Accepted solution]

Hi Clayton,

can you please check if your role name exists in the “PUBLIC”.”ROLES” table,if it does then you would be able to see which schema its under.

then try running the select current_schema from dummy.See if both are same,just an aspect i thought of.Hope it helps.

regards

Sayantan

[Claytoncbj · Accepted solution]

Yes. But they are with "

I had assigmented the ROLES by 'User Manage'. Is it ok?

[Claytoncbj · Accepted solution]

I recreate the role and user NO ". This solved the problem.