SQL Server/MSDE provides numerous system stored procedures you can use to create, delete, and edit server login names, database user names, server roles, database roles, and so on.
You can use these system stored procedures in your stored procedures, forms, reports, and VBA programs. Table 20-5 and Table 20-6 list the most important system stored procedures. After the tables we introduce a form that provides information about server login names, server roles, database user names, database roles, and so on.
The naming syntax for system stored procedures and their parameters always suppresses the second of two identical successive letters. For example, loginname with a double n becomes loginame ...