SQL Server Security DLL: Encapsulates Database Roles and Users

Category:
Database
Type:
Classes
Difficulty:
Intermediate
Author:
John Conwell

Version Compatibility: Visual Basic 6

More information:
This dll logs into the a SQL server, using admin L ogon and PW and fills out a class data model based on all the non-system defined roles associated to the provided database, and all the users assigned to each role. It uses SQLDMO in order to pull roles and users from a database. Also included is the UML class model that I used to design my classes. This can be viewed with Microsoft Visual Modeler

NOTES: For this class to work, you need to create roles and assign users to them in the SQL database. For the demo app to work, you need to change the login information and the role names in the form_load procedure. The included readme file contains the details.


Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download sqlsecurity.zip