In this blog post, let’s learn about the error message “1669 This command cannot use name-type name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1669 This command cannot use name-type name.
Reason for the Error
A GRANT or REVOKE command for a DDL privilege is executed on a schema of a shared tenant database, specifying a user or privilege group that is not associated with the database of the tenant. This error is thrown only in the tenant mode.
Solution
If the offending name is in error, correct the name and retry the operation
