SqlClientPermission Class
Collapse the table of content
Expand the table of content

SqlClientPermission Class

 

Enables the .NET Framework Data Provider for SQL Server to help make sure that a user has a security level sufficient to access a data source.

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

System.Object
  System.Security.CodeAccessPermission
    System.Data.Common.DBDataPermission
      System.Data.SqlClient.SqlClientPermission

[SerializableAttribute]
public sealed class SqlClientPermission : DBDataPermission

NameDescription
System_CAPS_pubmethodSqlClientPermission()

Obsolete.Initializes a new instance of the SqlClientPermission class.

System_CAPS_pubmethodSqlClientPermission(PermissionState)

Initializes a new instance of the SqlClientPermission class.

System_CAPS_pubmethodSqlClientPermission(PermissionState, Boolean)

Obsolete.Initializes a new instance of the SqlClientPermission class.

NameDescription
System_CAPS_pubpropertyAllowBlankPassword

Gets a value indicating whether a blank password is allowed.(Inherited from DBDataPermission.)

NameDescription
System_CAPS_pubmethodAdd(String, String, KeyRestrictionBehavior)

Adds a new connection string and a set of restricted keywords to the SqlClientPermission object.(Overrides DBDataPermission.Add(String, String, KeyRestrictionBehavior).)

System_CAPS_pubmethodAssert()

Declares that the calling code can access the resource protected by a permission demand through the code that calls this method, even if callers higher in the stack have not been granted permission to access the resource. Using Assert can create security issues.(Inherited from CodeAccessPermission.)

System_CAPS_pubmethodCopy()

Returns the SqlClientPermission as an IPermission.(Overrides DBDataPermission.Copy().)

System_CAPS_pubmethodDemand()

Forces a SecurityException at run time if all callers higher in the call stack have not been granted the permission specified by the current instance.(Inherited from CodeAccessPermission.)

System_CAPS_pubmethodDeny()

Obsolete.Prevents callers higher in the call stack from using the code that calls this method to access the resource specified by the current instance.(Inherited from CodeAccessPermission.)

System_CAPS_pubmethodEquals(Object)

Determines whether the specified CodeAccessPermission object is equal to the current CodeAccessPermission.(Inherited from CodeAccessPermission.)

System_CAPS_pubmethodFromXml(SecurityElement)

Reconstructs a security object with a specified state from an XML encoding.(Inherited from DBDataPermission.)

System_CAPS_pubmethodGetHashCode()

Gets a hash code for the CodeAccessPermission object that is suitable for use in hashing algorithms and data structures such as a hash table.(Inherited from CodeAccessPermission.)

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodIntersect(IPermission)

Returns a new permission object representing the intersection of the current permission object and the specified permission object.(Inherited from DBDataPermission.)

System_CAPS_pubmethodIsSubsetOf(IPermission)

Returns a value indicating whether the current permission object is a subset of the specified permission object.(Inherited from DBDataPermission.)

System_CAPS_pubmethodIsUnrestricted()

Returns a value indicating whether the permission can be represented as unrestricted without any knowledge of the permission semantics.(Inherited from DBDataPermission.)

System_CAPS_pubmethodPermitOnly()

Prevents callers higher in the call stack from using the code that calls this method to access all resources except for the resource specified by the current instance.(Inherited from CodeAccessPermission.)

System_CAPS_pubmethodToString()

Creates and returns a string representation of the current permission object.(Inherited from CodeAccessPermission.)

System_CAPS_pubmethodToXml()

Creates an XML encoding of the security object and its current state.(Inherited from DBDataPermission.)

System_CAPS_pubmethodUnion(IPermission)

Returns a new permission object that is the union of the current and specified permission objects.(Inherited from DBDataPermission.)

The IsUnrestricted property takes precedence over the AllowBlankPassword property. Therefore, if you set AllowBlankPassword to false, you must also set IsUnrestricted to false to prevent a user from making a connection using a blank password.

System_CAPS_noteNote

When using code access security permissions for ADO.NET, the correct pattern is to start with the most restrictive case (no permissions at all) and then add the specific permissions that are needed for the particular task that the code needs to perform. The opposite pattern, starting with all permissions and then denying a specific permission, is not secure, because there are many ways of expressing the same connection string. For example, if you start with all permissions and then attempt to deny the use of the connection string "server=someserver", the string "server=someserver.mycompany.com" would still be allowed. By always starting by granting no permissions at all, you reduce the chances that there are holes in the permission set.

.NET Framework
Available since 1.1

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft