Skip to content

Archive for

[Error 8017] [SQLState 28000] The UserId, Password or Account is invalid

ERROR:
Your lab group has not been created. [Teradata Database] [TeraJDBC 15.10.00.09] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

DESCRIPTION:
You may see above error while creating a new datalab group in viewpoint.

ISSUE:
You will see this error because the user with which you are creating data labs group do not have required permission on the underlying database where you are creating this data lab group.

RESOLUTION:
Grant below permissions to the user (sysdba in my example) and try creating the data lab group again.
GRANT USER ON DATALABS to sysdba;
GRANT CREATE ROLE to sysdba WITH GRANT OPTION;
GRANT EXECUTE ON DBC.LogonRule to sysdba;