In this blog post, let’s learn about the error message “1666 User user-name is not available.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1666 User user-name is not available.
Reason for the Error
A GRANT, REVOKE, ADD PRIVILEGE GROUP, or ALTER PRIVILEGE GROUP command, that was executed in the tenant mode specified a user grantee that is not associated with the tenant’s database. This is permitted only when the tenant database is shared.
Solution
If the offending name is in error, correct the name and retry the operation. Alternatively, consider if the offending user should be added to the tenant database or if the tenant database should be shared
