You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "David Sean Taylor (JIRA)" <je...@portals.apache.org> on 2006/07/19 23:22:14 UTC
[jira] Created: (JS2-560) Normalize Principal table
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
[jira] Updated: (JS2-560) Normalize Principal table
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ https://issues.apache.org/jira/browse/JS2-560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Sean Taylor updated JS2-560:
----------------------------------
Fix Version/s: (was: 2.1-dev)
2.2-dev
Affects Version/s: (was: 2.1-dev)
2.2-dev
Moving to post 2.1 release
> Normalize Principal table
> -------------------------
>
> Key: JS2-560
> URL: https://issues.apache.org/jira/browse/JS2-560
> Project: Jetspeed 2
> Issue Type: Improvement
> Components: Security
> Affects Versions: 2.2-dev
> Reporter: David Sean Taylor
> Assigned To: David Sean Taylor
> Fix For: 2.2-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.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
[jira] Commented: (JS2-560) Normalize Principal table
Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
[ http://issues.apache.org/jira/browse/JS2-560?page=comments#action_12456960 ]
David Sean Taylor commented on JS2-560:
---------------------------------------
Will address this after 2.1 release
> 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