SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

[former_member389878]

Dear Experts,

I'm trying to run this SQL

But getting this error,

I have all the required Privileges including Admin Privilege on the system.

Could you please suggest, What privileges are missing ?

[VivekSahu]

Can you mention what SQL and which user you are trying to execute ?

[former_member389878]

APologies, Missed the SQL in the question.

I'm running this SQL

ALTER SYSTEM REFRESH RESULT CACHE "_SYS_BIC"."XXX.TEST/CV_TEST_CACHE"

I get the below error

Could not execute 'ALTER SYSTEM REFRESH RESULT CACHE "_SYS_BIC"."XXX.TEST/CV_TEST_CACHE"'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Please note : I'm running the SQL in TEST Schema. I own this Schema. I also have ALTER privilege on this Schema.

Kindly assist with your valuable inputs.

[pfefferf]

You mentioned that you have the "ALTER" privilileges on your schema. That means that you have only priviliges for e.g. DDL statements changing the definition of your objects in that specific schema.

But you are trying to alter the result cache of an object. For that the system privilege "OPTIMIZER ADMIN" is required. Please check the documentation here.

[former_member389878]

Thank you Florian.

I just for the OPTIMIZER ADMIN Privilege and looks like I have that role as well. Please see below attachment.

roles.png. I still get the same authorization error.

[AtulKumarJain]

hi,

Do you have access to schema where you are running the SQL.

Please check and try again.

BR

Atul