User (principal) name in MetaMatrix should be consistently the same string -------------------------------------------------------------------------- Key: TEIID-966 URL: https://jira.jboss.org/jira/browse/TEIID-966 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Debbie Steigner Assignee: Steven Hawkins The issue has to do with the way we represent a user's name. Customer uses LDAP for a membership domain. Sometimes, the user's name is their cn, followed by "@" plus the domain name, e.g.: username@LDAP Sometimes, it's simply the user name. e.g.: username This name is recorded in the audit logs, used throughout Console, and perhaps most importantly, is the name returned by the USER() system function. The problem is that we use the return value of USER() to record information about who is doing things. Later, we make comparisons against this info to control access, etc. This comparison often fails, even though we may be comparing the same identity, due to this inconsistency. Workaround for the USER() function: build in special logic within each procedure to strip out the @LDAP if it is present.