Permissions
Permissions are used to control access to database objects and schemas and to specify which users can perform certain database actions. You can set both server and database permissions. Server permissions are used to allow DBAs to perform database administration tasks. Database permissions are used to allow or disallow access to database objects and statements. In this section, we’ll look at the types of permissions and how to allocate them.
Server Permissions
Server permissions are assigned to DBAs to allow them to perform administrative tasks. These permissions are defined on the fixed server roles. User logins can be assigned to the fixed server roles, but these roles cannot be modified. (Server roles are explained in the section ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
