DROP IDENTITY PROVIDER
Deletes an identity provider. This command isn't reversible. Only a superuser can drop an identity provider.
Syntax
DROP IDENTITY PROVIDER identity_provider_name [ CASCADE ]
Parameters
- identity_provider_name
-
Name of the identity provider to delete.
- CASCADE
-
Deletes users and roles attached to the identity provider, when it is deleted.
Example
The following example deletes the oauth_provider identity provider.
DROP IDENTITY PROVIDER oauth_provider;
If you drop the identity provider, some users may not be able to log in or use client tools configured to use the identity provider.