Managing Permissions with the SQL Server 2005 Database Engine
(Page 1 of 4 )
In this third part of a six-part series on administering the SQL Server 2005 database engine, you'll learn how to handle the permissions page and several of the important folders. This article is excerpted from chapter one of the book
SQL Server 2005 Management and Administration, written by Chris Amaris, Alec Minty and Ross Mistry (Sams Publishing, 2008; ISBN: 0672329565).
Administering the Permissions Page
The Permissions Page, as shown in Figure 1.8, includes all the authorization logins and permissions for the SQL Server instance. You can create and manage logins and/or roles within the first section. The second portion of this page displays the Explicit permission based on the login or role.
For more information on permissions and authorization to the SQL Server 2005 Database Engine, refer to Chapter 13, “Administering SQL Server Security.”
Figure 1.8. Administering the Server Properties Permissions page.
Administering the SQL Server Database Engine Folders
After you configure the SQL Server properties, you must manage the SQL Server Database Engine folders and understand what and how the settings should be configured. The SQL Server folders contain an abundant number of configuration settings that need to be managed on an ongoing basis. The main SQL Server Database Engine top-level folders, as shown in Figure 1.9, consist of
- Databases ■ Replication
- Security ■ Management
- Server Objects ■ Notification Services
Figure 1.9. Viewing the Database Engine folders.
Each folder can be expanded upon, which leads to more subfolders and thus more management of settings. The following sections discuss the folders within the SQL Server tree, starting with the Databases folder.
Next: Administering the Databases Folder >>
More Database Articles
More By Sams Publishing
/ 3 
