O'Reilly logo

Visual Basic® .NET Database Programming by Rod Stephens

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

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

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