SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Database Engine

Security Considerations for Databases and Database Applications

Server-Level Roles

bulkadmin

dbcreator

diskadmin

processadmin

securityadmin

serveradmin

setupadmin

sysadmin

Minimize

1 out of 5 rated this helpful - Rate this topic

Server-Level Roles

SQL Server 2005

Fixed server roles are server-wide in their scope. Each member of a fixed server role can add other logins to that same role.

The fixed server roles are:

Concepts

Permissions of Fixed Server Roles

Other Resources

sp_helpsrvrole (Transact-SQL)
sp_helpsrvrolemember (Transact-SQL)
sp_srvrolepermission (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.