CA Datacom SQL Security › Implementing the SQL Security Model › Adding View Security Authorizations › Name Length Limitations

Name Length Limitations

While reading the resource name formats be aware that the length of each name is limited by the external security package being used. Assuming an 8-character Directory (CXX) name and an external security package that, in an extremely restrictive case, could limit you to 44-byte resource names, the total combined length of the SQL authorization ID and the SQL view name that could be secured could be as short as 28 characters. If, for example, the longest authorization ID in your system is 12 characters long, the longest view name should be 16 characters or less. Check the limits of your external security package and name your views accordingly. Remember that 16 characters of the resource name are reserved for use by SQL (for purposes such as the CXX name).