[teiid-issues] [JBoss JIRA] Moved: (TEIID-966) User (principal) name in MetaMatrix should be consistently the same string

[Van Halbert (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Van Halbert moved JBEDSP-1097 to TEIID-966:
-------------------------------------------

              Project: Teiid  (was: JBoss Enterprise Data Services Platform)
                  Key: TEIID-966  (was: JBEDSP-1097)
          Component/s: Query Engine
                           (was: Server)
        Fix Version/s:     (was: Westport)
    Affects Version/s:     (was: 5.5.2)
                           (was: 5.5.3)
                           (was: 5.5.1)
                           (was: 5.5)


> 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 at 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira