Security for Microsoft® Visual Basic® .NET

SQL Server Authorization

SQL Server has a rich authorization model. You can assign permissions to any SQL server object that performs an action or touches data in a database: stored procedures, views, columns, and tables. Within individual tables, you can, with some effort, assign privileges to individual columns and rows. Most applications need to apply one or more of the three types of table authorization:

• Table Level. Each user has specific read or write access to the contents of an entire table. This can be set up by using the Properties dialog box of each table object from within SQL Server Enterprise Manager.

• Column Level. Each user has specific read or write access to a particular column (or field) of a table. These permissions can also be ...