Teradata Database Message 3583 - 3583 - Analytics Database - Teradata Vantage

Message

Too many HostIDs and UserIDs listed in GRANT/REVOKE LOGON.

Explanation

The GRANT/REVOKE LOGON statement creates or updates a dictionary table row, and generates other steps, for each HostId-UserId combination. If the product of the number of HostIds and UserIds listed in a single GRANT/REVOKE LOGON statement exceeds 25, the steps generated will require more memory space than is available to parse and execute the statement.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Separate the statement into two or more statements each having a small enough number of HostIds and UserIds such that (HostID Count * UserId Count) \<= 25.