Udostępnij za pośrednictwem

ServerUserProfiles Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Common
Assembly:
Microsoft.SqlServer.ConnectionInfo.dll
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
Package:
Microsoft.Data.Tools.Msbuild v16.0.62004.28040
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

This enumeration supports a bitwise combination of its member values.

[System.Flags]
public enum ServerUserProfiles
[<System.Flags>]
type ServerUserProfiles = 
Public Enum ServerUserProfiles
Inheritance
Enum
ServerUserProfiles
Attributes
FlagsAttribute

Fields

Name Value Description
None 0
SALogin 1

Login is a member of the sysadmin role.
CreateDatabase 2

Login has CREATE DATABASE permission.
CreateXP 4

Login can execute sp_addextendedproc and sp_dropextendedproc (loading and unloading extended stored procedures).
All 7

Login has all specifiable SQL Server maintenance permissions.

Applies to