Managing principals through ScfUtils (Model Explorer)
This topic covers adding, deleting, and changing principal roles through ScfUtils.
ScfUtils provides a command line interface for performing Model Explorer functions.
If you have installed Modeler to the default locations, ScfUtils resides in the following location:
<<INSTALLDIR>>\Modeler\Exe\SCFUtils.exe
For information about managing principals by using Model Explorer, see the following topics:
To add a principal through ScfUtils
Syntax:
ScfUtils -addprincipal Enterprise "<database-ref>" "<user/group>" "<isAdmin>" "<accessPermission>"
Where:
• <database-ref> specifies the reference to the database to which the principal will be added.
Enter the database reference in the following format: \\SQL\<instance-name>\<database>
• <user/group> specifies a name for the user or group to add.
Type the domain followed by the Windows user or group name.
• <isAdmin> specifies whether the principal user or group is added as a database administrator.
Type 1 to set the principal to a database administrator.
Type 0 to set a standard principal.
• <accessPermission> specifies whether the user has access to read, write or no access to the database
Type 0 to provide no permission to the database
Type 1 to provide Read permission to the user
Type 2 to provide Write permission to the user
Example:
ScfUtils -addprincipal Enterprise "\\SQL\Server1@MODELER\ModelsDB" "domain\user" "1" "2"
To change a principal role through ScfUtils
Syntax:
ScfUtils -changeprincipalrole Enterprise "<database-ref>" "<user/group>" "<isAdmin>" "<accessPermission>"
Where:
• <database-ref> specifies the reference to the database in which the principal role will be changed.
Enter the database reference in the following format: \\SQL\<instance-name>\<database>
• <user/group> specifies a name for the user or group to change.
Type the domain followed by the Windows user or group name.
• <isAdmin> specifies whether the principal user or group role is set to a database administrator.
Type 1 to set the principal to a database administrator.
Type 0 to set a standard principal.
• <accessPermission> specifies the updated permission for the specified user
Type 0 to provide no permission to the user
Type 1 to provide Read permission to the user
Type 2 to provide Write permission to the user
Example:
ScfUtils -changeprincipalrole Enterprise "\\SQL\Server1@MODELER\ModelsDB" "domain\user" "1" "0"
To delete a principal through ScfUtils
Syntax:
ScfUtils -deleteprincipal Enterprise "<database-ref>" "<user/group>"
Where:
• <database-ref> specifies the reference to the database from which the principal will be deleted.
Enter the database reference in the following format: \\SQL\<instance-name>\<database>
• <user/group> specifies a user or a group name to delete.
Type the domain followed by the Windows user or group name.
Example:
ScfUtils -deleteprincipal Enterprise "\\SQL\Server1@MODELER\ModelsDB" "domain\user"