How To Administer SQL Server Security via RDO and ADO (183621)
The information in this article applies to:
- Microsoft Visual Basic Enterprise Edition for Windows 5.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
- ActiveX Data Objects (ADO) 1.5
- ActiveX Data Objects (ADO) 2.0
- ActiveX Data Objects (ADO) 2.1 SP2
- ActiveX Data Objects (ADO) 2.5
- ActiveX Data Objects (ADO) 2.6
This article was previously published under Q183621 SUMMARY
This article describes how to use RDO and ADO via Visual Basic to
do basic SQL Server security administration for a SQL Server that is configured with standard security (as opposed to the integrated or mixed security models). Specifically, this article demonstrates how to add a login to a SQL Server, how to add a user to a SQL Server database, how to add a group to a SQL Server database, and how to add a user to a group. Other security-related functions (such as dropping a user from a database and dropping a login from an SQL Server) can be accomplished by applying similar techniques to those discussed below.
It is assumed that the person connecting to SQL Server to manipulate the
security settings is either the system administrator (SA) or has a login
that is aliased to the SA.
Modification Type: | Minor | Last Reviewed: | 3/14/2005 |
---|
Keywords: | kbhowto kbRDO KB183621 |
---|
|