Skip to main content

Automate Database Maintenance - User Class Permission Sync

Summary

This script is called from CWM - Automate - Script - Automate Database Maintenance Solution. It handles the user class permission for the clients and requires the "UserClass_Enable_Default_Permission" system property value to be set to 1 to enable synchronization of user class permissions from the Default Client to all other clients.

Sample Run

This script is a function script called from CWM - Automate - Script - Automate Database Maintenance Solution.

Variables

NameDescription
EnableUserClassSyncThis variable verifies if the property UserClass_Enable_Default_Permission is set to 1 or 0.
LogMessageThis is the running log holding variable. Please note this variable is always set the same everywhere it's used in the solution. @logMessage@ = @LogMessage@[Linebreak]%when% : [Category] Cleanup [Stage] - Result. Please continue to utilize this standard with this running log file.
DefaultClientidThis variable verifies if the property UserClass_Default_Clientid is not set to 0.
VerifyDefaultClientIDThis variable verifies that the client ID mentioned in the variable DefaultClientid should not belong to any client that has already been offboarded.
ExcludedClientIDThis variable fetches the value of the property "UserClass_Excluded_Client".

Properties

NameDescription
DBCleanup_UserClass_Enable_Default_PermissionSet it to "1" to enable synchronization of user class permissions from the Default Client to all other clients.
DBCleanup_UserClass_Default_ClientidSpecify the client's client ID from which you would like to copy the permissions to other clients.
DBCleanup_UserClass_Excluded_ClientsSpecify the client IDs you would like to exclude from receiving the default user class permissions.

Output

This script will add the logs to the log variable.