O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

System Stored Procedures for Users and Roles

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.

Note

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required