How to fix the Oracle error ORA-13752: User “string” must be SYS or must have the “ADMINISTER ANY SQL TUNING SET” privilege.?

In this post, you’ll learn more about the Oracle ErrorORA-13752: User “string” must be SYS or must have the “ADMINISTER ANY SQL TUNING SET” privilege. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-13752: User “string” must be SYS or must have the “ADMINISTER ANY SQL TUNING SET” privilege.

Reason for the Error ORA-13752: User “string” must be SYS or must have the “ADMINISTER ANY SQL TUNING SET” privilege.

The attempted to create a SQL Tuning Set in another schema without having the right privilege.

How to fix the Error ORA-13752: User “string” must be SYS or must have the “ADMINISTER ANY SQL TUNING SET” privilege. ?

You can fix this error in Oracle by following the below steps

Connect as SYS or adjust the user’s privilege and retry the operation.