portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Sean Taylor (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Created: (JS2-560) Normalize Principal table
Date Wed, 19 Jul 2006 21:22:14 GMT
Normalize Principal table

                 Key: JS2-560
                 URL: http://issues.apache.org/jira/browse/JS2-560
             Project: Jetspeed 2
          Issue Type: Improvement
          Components: Security
    Affects Versions: 2.1-dev
            Reporter: David Sean Taylor
         Assigned To: David Sean Taylor
             Fix For: 2.1-dev

The SECURITY_PRINCIPAL table  is not in normalized form. A number of users have complained
about the principal tables not being normalized with the principal name in its own  column,
as well as the principal type in its own column. There are always needs to join to  the user
tables, and without normalized columns, it makes simple joins difficult for integrators.

I have also seen requests for additional columns on the principal tables. Normally I recommend
joining for these columns, or putting them in the user  attributes. However I will consider
doing so.

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


To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org

View raw message