In this blog post, let’s learn about the error message “1017 You are not authorized to perform this operation.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1017 You are not authorized to perform this operation.
Reason for the Error
You attempted a DDL or utility operation without proper authorization, or remote password validation failed.
Solution
Reissue the command with the proper authorization.
DDL and utility operations are restricted as follows:
Operations on a database catalog are restricted to the catalog owner only.
Operations on a database schema are restricted to the schema owner only.
Operations on a database object are restricted to the schema owner and the object owner.
In all cases, if super.super is a security administrator or security administrators are not defined, super.super is authorized to perform DDL and utility operations.
Also, invalid remote password for the user might trigger this error. Verify the remote password for the user and resubmit.
NOTE:
The error descriptions of SQL messages 1017 and 25258 are same
