Authorization issue to object

[Former Member]

I am facing the below error. I am not able to unload the objects. what kind of authorization objects i need to assign?

[46576]{309232}[372/-1] 2015-07-10 06:32:33.228463 i Authorization	query_check.cc(02544) : User XYZ tried to execute 'unload "SAP<SID>"."EDID4" '
[46611]{309241}[236/-1] 2015-07-10 06:36:02.050088 i TraceContext	TraceContext.cpp(00702) : UserName=XYZ, ApplicationUserName=ABC, ApplicationName=HDBStudio, ApplicationSource=csns.sql.editor.SQLExecuteFormEditor$2$1.run(SQLExecuteFormEditor.java:856);
[46611]{309241}[236/-1] 2015-07-10 06:36:02.050064 i Authorization	SQLFacade.cpp(01075) : UserId(5514254) is not authorized to do SQL_ACT_UPDATE on ObjectId(2,0,oid=259228)
[46611]{309241}[236/-1] 2015-07-10 06:36:02.050602 i Authorization	SQLFacade.cpp(01496) :
	system-action : none
	SCHEMA-146594-SAP<SID> : {} , {SQL_ACT_UPDATE}
	TABLE-259228-EDID4 : {SQL_ACT_UPDATE} , {}

[former_member270797 · Accepted solution]

Hi Pavan,

you need update (SQL_ACT_UPDATE) privileges on the table.

Best regards.

Moritz

[Former Member · Accepted solution]

Hi Moritz,

From the log i am able to see that. how to do that ?

[former_member270797 · Accepted solution]

Hi Pavan,

you can do it for example via the studio. You need a user which has the update priv with grantable to others. Then click on your user under security, go to object privileges, search for the table and grant the privilege.

Another option is using a GRANT statement. Please see the SQL Reference for details.

Best regards.

Moritz

[Former Member · Accepted solution]

Hi Moritz,

I tried that.. but still i am not able to assign . I feel very strange.

[46591]{310875}[354/-1] 2015-07-10 11:24:03.147695 i TraceContext	TraceContext.cpp(00702) : UserName=SYSTEM, ApplicationUserName=ABC, ApplicationName=HDBStudio, ApplicationSource=csns.authorization.AuthorizationPlugin$ConnectionRunner$1.call(AuthorizationPlugin.java:452);csns.authorization.AuthorizationPlugin$ConnectionRunner$1.call(AuthorizationPlugin.java:1);java.util.concurrent.FutureTask.run(FutureTask.java:266);java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142);java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617);java.lang.Thread.run(Thread.java:812);
[46591]{310875}[354/-1] 2015-07-10 11:24:03.147682 i Authorization	SQLFacade.cpp(01075) : UserId(131074) is not authorized to grant SQL_PRIV_UPDATE on ObjectId(2,0,oid=259228)
[46591]{310875}[354/-1] 2015-07-10 11:24:03.153382 i Authorization	SQLFacade.cpp(01494) : check for GRANT/REVOKE
[46591]{310875}[354/-1] 2015-07-10 11:24:03.153384 i Authorization	SQLFacade.cpp(01496) :
	system-action : none
	SCHEMA-146594-SAP<SID> : {} , {SQL_PRIV_UPDATE}

[former_member270797 · Accepted solution]

Hi Pavan,

from the trace output it seems that the user (UserId 131074) which you are using to grant the update priv also does not have sufficient privileges.

Did you try it with the schema owner?

Best regards.

Moritz

[Former Member · Accepted solution]

I used SYSTEM user for granting privileges. Do you mean to say ...try to give authorization using SAPSID user ?

I will not able to login using SAPSID

[former_member270797 · Accepted solution]

Hi Pavan,

well, the SYSTEM user does not have UPDATE privileges with grant option for the SAPSID by default.Please see the chapter "Object Privileges" in the developer guide.

Did you check the privileges of the SYSTEM user?

If no other user owns the UPDATE priv on the table you have to do it with the SAPSID user or use the SAPSID user to grant the privileges to your user.

Best regards.

Moritz