Error while writing file: User is not authorized to execute specified operation

[former_member457389]

extend-packages.png

Hi Experts,

I try to extend the package "ms.sp" with the privileges:

'REPO.EDIT_IMPORTED_OBJECTS'

'REPO.EDIT_IMPORTED_OBJECTS'

'REPO.MAINTAIN_IMPORTED_PACKAGES'

unfortunately i get this error message :Trace:

[67799]{227071}[163/658797339] 2019-03-04 11:15:13.942117 i TraceContextTraceContext.cpp(01043) : UserName=USER_01, ApplicationUserName= USER_01, ApplicationName=HDBStudio, ApplicationSource=csns.admin.AdminConnection.openConnection(AdminConnection.java:99);csns.admin.trace.wizard.TraceUserPage$6$1.call(TraceUserPage.java:329);csns.admin.trace.wizard.TraceUserPage$6$1.call(TraceUserPage.java:1);, Client=050, StatementHash=9199d95d5febb218df73fe6e92f01ff8

[67799]{227071}[163/658797339] 2019-03-04 11:15:13.942108 i SQLSessionCmdStatement.cc(06885) : INI configuration is changed by 227071, client ip=XXX.XX.XXX.XXX, client port=XXXX, query=alter system alter configuration ('indexserver.ini','SYSTEM') SET ('traceprofile_user', 'application_user') = ' USER_01' with reconfigure

for more Infos please see Attachment. What should i do in this case? Many Thanks for your Answer.

br, Khoja

[former_member457389]

All roles are created / saved under the ms.sec.ro. And there I try to expand my role with the missing privileges. But I have a role with all "*_IMPORTED_*" privileges but under this Packages in Screenshot. that why do you think the system is avoiding to save the role? If you have a example, it will be great. Many Thanks.

[pfefferf]

Is the role, which you are trying to edit, imported? If yes, then user is simply missing the privilege, like mentioned in the error message.

PS: In case you are trying to edit a role imported on the e.g. QA system, I think that is not the way you wanna proceed.

[former_member457389]

Hi Florian,

The role is not imported. The user has implemented a new packages named "ms.sp" for his development and when he activates his objects he gets this error message, so I wanted to assign him this privilege. See details in the screenshot. That's why i tried to extend his role with the neede privilege. Thanks.

regards.

[pfefferf]

That what you describe is why you are trying to enhance the role with the necessary privileges, which is absolutely fine. But as you can see on your screenshot the error message avoiding changing the role, is related to the role stored in package ms.sec.ro.

[former_member457389]

Hi Florian,

my problem is now i am not able to expand/Change any other role.

regards,

khalid

[former_member457389]

Hi,

Problem solved by assigning me the privilges: 'REPO.EDIT_IMPORTED_OBJECTS' on the packages 'ms.sec.ro'.

br, Khalid