User Properties: Cannot add user properties to external users (LDAP)

Description

Provided users (LDAP for example), cannot have user properties because there’s a foreign key constraint in the SAKAI_USER_PROPERTY table referencing a SAKAI_USER record.

Since Sakai can deal with external users, only present in SAKAI_USER_ID_MAP, the foreign key restriction prevents these users to have properties.

In similar cases, like SAKAI_PREFERENCES, this restriction does not exist, both users can have preferences. For consistency reason the foreign key does not make sense.

Activity

Show:

Miguel Pellicer April 11, 2023 at 2:18 PM

We need conversion scripts for this.

 

Automation for Jira November 9, 2022 at 11:33 AM

A pull request has been created, "SAK-48034 User Properties: Cannot add user properties to external use…", you can see it at https://github.com/sakaiproject/sakai/pull/10989

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Conversion Script Required

Yes

Environment

MySQL and Oracle
Created November 9, 2022 at 11:23 AM
Updated March 8, 2024 at 11:31 AM
Resolved November 10, 2022 at 9:12 AM