Listing 7.5[md]You Can Perform Some Security System Maintenance Using Commands from Visual Basic
'*************************************
'Add a new user to the system database
'*************************************
Dim OldWs As Workspace, NewUser As User, NewGrp As Group
DBEngine.IniPath = "C:\VB4\TEST1.INI"
Set OldWs = DBEngine.Workspaces(0)
Set NewUser = OldWs.CreateUser("BJONES", "44587", "HOOPS")
OldWs.Users.Append NewUser
'**************************
'Add a user to a user group
'**************************
Dim OldWs As Workspace, NewUser As User, NewGrp As Group
DBEngine.IniPath = "C:\VB4\TEST1.INI"
Set OldWs = DBEngine.Workspaces(0)
Set NewUser = OldWs.CreateUser("BJONES", "44587", "HOOPS")
OldWs.Groups("Users").Users.Append NewUser
'**************************************
'Delete a user from the system database
'**************************************
Dim OldWs As Workspace, NewUser As User, NewGrp As Group
DBEngine.IniPath = "C:\VB4\TEST1.INI"
Set OldWs = DBEngine.Workspaces(0)
OldWs.Users.Delete "BJONES"