dx_ctl_users

SYNOPSIS

dx_ctl_users.pl [ -engine|d <delphix identifier> | -all ] 
                [-file filename] 
                [-profile filename] 
                [-help|?] 
                [-debug]

DESCRIPTION

Control an users in Delphix Engine using a CSV file

ARGUMENTS

Delphix Engine selection - if not specified a default host(s) from dxtools.conf will be used.

• -engine|d Specify Delphix Engine name from dxtools.conf file
• -all Display databases on all Delphix appliance

Options

• **-file filename ** CSV file name with user definition and actions Field list command, username, firstname, lastname, email, workphone, homephone, mobilephone, authtype, principal, password, is_admin
• **-profile filename ** CSV file name with user profile definition. It can be generated using dx_get_users profile option. Field list username, target_type, target_name, role

OPTIONS

• -help
  Print this screen
• -debug Turn on debugging

EXAMPLES

Add user to one engine using example users file

dx_ctl_users -d Landshark5 -file dxusers.csv.example
User testuser exist. Skipping
User testuser2 created.
User user11 doens't exist. Can't update
User testuser updated. Password for user testuser updated.
User testuser2 deleted.

Add user to one engine using users file and profile file

dx_ctl_users -d Landshark5 -file /tmp/users.csv -profile /tmp/profile.csv 
User sysadmin exist. Skipping
User delphix_admin exist. Skipping
User dev_admin exist. Skipping
User qa_admin created.
User dev exist. Skipping
User qa exist. Skipping
Role OWNER for target Dev Copies set for dev_admin
Role PROVISIONER for target Sources set for dev_admin 
Role PROVISIONER for target Dev Copies set for qa_admin 
Role OWNER for target QA Copies set for qa_admin

Example csv user file:

# operation,username,first_name,last_name,email address,work_phone,home_phone,cell_phone,type(NATIVE|LDAP),principal_credential,password,admin_priv,js_user 
# comment - create a new user with Delphix authentication 
C,testuser,Test,User,[email protected],,555-222-222,,NATIVE,,password,Y
# comment - create a new user with LDAP 
C,testuser2,Test,User2,[email protected],555-111-111,555-222-222,555-333- 333,LDAP,"[email protected]",,Y
# update existing user - non-empty values will be updated, password can't be modified in this version 
U,user11,FirstName,LastName,[email protected],,,,,,, U,testuser,Test,User,[email protected],,555-222-333,,NATIVE,,password,Y
# delete user
D,testuser2,,,,,,,,,,

Example csv profile file:

#Username,Type,Name,Role
testusr,group,Break Fix,AUDITOR
testusr,group,QA Copies,AUDITOR 
testusr,group,Sources,AUDITOR
testusr,databases,ASE pubs3 DB,OWNER 
testusr,databases,AdventureWorksLT2008R2,AUDITOR 
testusr,databases,Agile Masking,AUDITOR 
testusr,databases,Employee Oracle DB,OWNER