SqlClientPermission Class

Definition

Namespace:

Microsoft.Data.SqlClient

Assembly:

Microsoft.Data.SqlClient.dll

Package:

Microsoft.Data.SqlClient v5.2.0

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.

public ref class SqlClientPermission sealed : System::Data::Common::DBDataPermission

[System.Serializable]
public sealed class SqlClientPermission : System.Data.Common.DBDataPermission

[<System.Serializable>]
type SqlClientPermission = class
    inherit DBDataPermission

Public NotInheritable Class SqlClientPermission
Inherits DBDataPermission

Inheritance

DBDataPermission

SqlClientPermission

Attributes

SerializableAttribute

Remarks

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.

Note

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.

Constructors

SqlClientPermission()	Obsolete. Initializes a new instance of the SqlClientPermission class.
SqlClientPermission(PermissionState, Boolean)	Obsolete. Initializes a new instance of the SqlClientPermission class.
SqlClientPermission(PermissionState)	Initializes a new instance of the SqlClientPermission class.

Methods

Add(String, String, KeyRestrictionBehavior)	Adds a new connection string and a set of restricted keywords to the SqlClientPermission object.
Copy()	Returns the SqlClientPermission as an IPermission.
FromXml(SecurityElement)	Reconstructs a security object with a specified state from an XML encoding.
Intersect(IPermission)	Returns a new permission object representing the intersection of the current permission object and the specified permission object.
IsSubsetOf(IPermission)	Returns a value indicating whether the current permission object is a subset of the specified permission object.
ToXml()	Creates an XML encoding of the security object and its current state.
Union(IPermission)	Returns a new permission object that is the union of the current and specified permission objects.