sys.ldap_sync ​

Synchronize LDAP users and groups.

premdb=# select sys.ldap_sync();
               ldap_sync                 
------------------------------------------
 LDAP authorization data was synchronized+
 
(1 row)

Based on your current LDAP configuration, the Yellowbrick cluster synchronizes with the users and groups in the LDAP directory and creates users and roles with the same credentials. See also Synchronizing Users and Groups, which explains how to use the SMC for this purpose.

CONTROL LDAP privilege is required. Unauthorized users will see this message:

premdb=> select sys.ldap_sync();
                                  ldap_sync                                   
-------------------------------------------------------------------------------
 permission denied to query sys.ldap_sync(). CONTROL LDAP privilege is needed.
(1 row)

Note: This function cannot be used in a query that has a FROM clause (with table references).

Parent topic:System Functions