Unix enabled users who are members of Unix enabled groups are unable to connect successfully to DB2. The following error is reported
"SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation".In this case the user and group names were mixed case in Active Directory. DB2 is intolerant of mixed case names.
Ensure individual user and group names in Active Directory are either all uppercase or all lowercase.
i.e. user “MacTheKnife” and group “Crooners” will be unable to connect to DB2 since the names are mixed case.
however
user “mactheknife” and group ”CROONERS” will be able to connect since each individual name is either all uppercase or all lowercase.
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center