SQL Server provides a large assortment of stored procedures that you can use to manage security. You can use SQL Server tools to execute these procedures or you can write a Visual Basic program to execute them. The RunScript program described in Chapter 6, “Database Connections,” can execute these statements, as well as standard SQL commands.
The following sections describe the SQL Server stored procedures that are most useful in managing server and database access.
A database login allows a user to connect to SQL Server. This does not automatically allow the user to connect to a database served by SQL Server. The next section explains how to allow access to a database.
SQL Server can use two ...