SQL Server Security Procedures

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.

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

Get Visual Basic® .NET Database Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.