, , . . 23.11 ( ), .
. 23.11
( )
, ( ) | |||
UserForm | Name | Form1 | , . |
Caption | SQL-DMO (4) | . | |
Frame | Name | Frame1 | |
Caption | SQL Server | Combo1. | |
ComboBox | Name | Combo1 | ( ) . |
Frame | Name | Frame2 | |
Caption | List1. | ||
ListBox | Name | List1 | Combo1 . |
TextBox | Name | Text1 | login. |
CommandButton | Name | CmdCreate | . |
Caption | |||
CommandButton | Name | CmdExit | . |
Caption |
23.4 , . 23.12 . Form_Load Combo1 ( 1417). Combo1_Click ( 20), () . obj1(Trim(Combo1.Text)).Users ( 32) Name ( 33).
23.4
1: Dim sqlOb As SQLDMO.SQLServer
2: Dim obj1 As Object
3:
4:
5: Private Sub Form_Load()
6:
7: Set sqlOb = New SQLDMO.SQLServer
8:
9: ' SQL Server :
10: sqlOb.Connect "TOSHIBA-USER", "sa", ""
11: Set obj1 = sqlOb.Databases
12:
13: ' Combo1 :
14: For Each dbs In obj1
15: Combo1.AddItem dbs.Name
16: Combo1.Text = dbs.Name
17: Next dbs
18:
19: ' ""Combo1:
20: Combo1_Click
21:
22: End Sub
23:
24:
25: Private Sub Combo1_Click()
26: ' List1 Combo1
27:
28: Frame2.Caption = " '" & Trim(Combo1.Text) & "'"
29:
30: List1.Clear
31:
32: For Each tbl In obj1(Trim(Combo1.Text)).Users
33: List1.AddItem tbl.Name
34: Next tbl
35:
36: End Sub
37:
38: Private Sub CmdCreate_Click()
39: '
40:
41: Dim SQLDMOLogins As SQLDMO.Logins
42: Dim SQLDMOLogin As SQLDMO.Login
|
|
43: Dim SQLDMOuser As SQLDMO.User
44: Dim SQLDMOdatabase As SQLDMO.Database
45:
46: ' :
47: Set SQLDMOdatabase = obj1(Trim(Combo1.Text))
48:
49:
50: ' Logins:
51: Set SQLDMOLogins = sqlOb.Logins
52:
53: ' Login:
54: Set SQLDMOLogin = New SQLDMO.Login
55: SQLDMOLogin.Name = Text1.Text
56: SQLDMOLogin.Type = SQLDMOLogin_Standard
57:
58: ' Login Logins:
59: SQLDMOLogins.Add SQLDMOLogin
60:
61: ' User
62: Set SQLDMOuser = New SQLDMO.User
63: SQLDMOuser.Login = SQLDMOLogin.Name
64: SQLDMOuser.Name = SQLDMOLogin.Name & "_user"
65:
66: ' :
67: SQLDMOdatabase.Users.Add SQLDMOuser
68:
69: sqlOb.Close
70:
71: Form_Load
72:
73: End Sub
74:
75:
76: Private Sub CmdExit_Click()
77:
78: sqlOb.Close
79: Unload Me
80:
81: End Sub
. 23.12
( )
3873 . login ( 5359) SQL Server user ( 6267) Combo1 . login user Form_Load ( 71), List1 (. 23.13). (3234) ( 30).
. 23.13
login user Form_Load, List1
. 23.14 ( Interprise Manager) SQL-DMO (4).
. 23.14
C ( Interprise Manager) SQL-DMO (4)