Task: Drop SAML provider
Requirements: Drop user identity for SAML provider i.e. remove the external identity for each user in SAML provider configuration
Issue: Unable to remove external identity in SAML provider configuration windows.
In recent attempt to drop user identity for SAML provider we removed it by hitting remove button and un-ticked SAML for each user. However, when my colleague tried to DROP SAML provider then it displayed an error saying that we need to remove the mapping. Later, we found that SAML provider settings for each user were still there.
Solution: At last, I had to use following SQL statement to drop the external identity for each user.
ALTER USER XYZ DROP IDENTITY FOR SAML PROVIDER SAML_PROVIDER
Result: We were able to drop SAML provider with no issue.
Findings: Could it be GUI bug? Is there a procedure to follow?
Suggestion: Anyway, if you have similar issue then please try SQL statement.