FixedServerRoles Enumeration

The FixedServerRoles enumeration contains values that are used to specify fixed server roles that can be assigned to logons.

네임스페이스: Microsoft.SqlServer.Management.Common
어셈블리: Microsoft.SqlServer.ConnectionInfo (in microsoft.sqlserver.connectioninfo.dll)

구문

‘선언
<FlagsAttribute> _
Public Enumeration FixedServerRoles
[FlagsAttribute] 
public enum FixedServerRoles
[FlagsAttribute] 
public enum class FixedServerRoles
/** @attribute FlagsAttribute() */ 
public enum FixedServerRoles
FlagsAttribute 
public enum FixedServerRoles

Members

Member name Description
BulkAdmin Administers bulk operations.
DBCreator Can create databases.
DiskAdmin Can alter resources.
None No server role.
ProcessAdmin Can alter connections.
SecurityAdmin Can alter logons.
ServerAdmin Can alter Microsoft SQL Server settings, shut down the SQL Server Service, create and alter endpoints, alter the SQL Server state, and alter resources.
SetupAdmin Can alter linked servers.
SysAdmin Can control any aspect of the instance of Microsoft SQL Server.

주의

The FixedServerRoles class is served by the ServerConnection class.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

Microsoft.SqlServer.Management.Common Namespace

관련 자료

sp_helpsrvrole(Transact-SQL)