SecurityPolicy Class
Represents the security policy.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Microsoft.SqlServer.Management.Smo::SmoObjectBase
Microsoft.SqlServer.Management.Smo::SqlSmoObject
Microsoft.SqlServer.Management.Smo::NamedSmoObject
Microsoft.SqlServer.Management.Smo::ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo::ScriptSchemaObjectBase
Microsoft.SqlServer.Management.Smo::SecurityPolicy
| Name | Description | |
|---|---|---|
![]() | SecurityPolicy() | Initializes a new instance of the SecurityPolicy class. |
![]() | SecurityPolicy(Database^, String^) | Initializes a new instance of the SecurityPolicy class using the specified name and database. |
![]() | SecurityPolicy(Database^, String^, String^) | Initializes a new instance of the SecurityPolicy class. |
![]() | SecurityPolicy(Database^, String^, String^, Boolean, Boolean) | Initializes a new instance of the SecurityPolicy class. |
| Name | Description | |
|---|---|---|
![]() | CreateDate | Gets a created date for the security policy. |
![]() | DateLastModified | Gets the date and time the object was last modified. |
![]() | Enabled | Gets or sets whether the security policy is enabled. |
![]() | ExecutionManager | Gets the object to execute to the manager.(Inherited from SqlSmoObject.) |
![]() | ExtendedProperties | Gets the extended properties for the security policy. |
![]() | ID | Gets the ID security policy. |
![]() | IsSchemaBound | Gets or sets a value that indicates whether the security policy is schema bound. |
![]() | IsSchemaOwned | Gets a Boolean value that indicates whether the SecurityPolicy object is owned by a schema. |
![]() | Name | Gets or sets the name of the security policy.(Overrides ScriptSchemaObjectBase::Name.) |
![]() | NotForReplication | Gets or sets a value that indicates whether the security policy is not for replication. |
![]() | Owner | Gets or sets the owner for the security policy. |
![]() | Parent | Gets the Server object that is the parent of the Security Policy object. |
![]() | Properties | Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.) |
![]() | Schema | Gets or sets the security policy for the schema object.(Overrides ScriptSchemaObjectBase::Schema.) |
![]() | SecurityPredicates | Gets the security predicates. |
![]() | State | Gets the state of the referenced object.(Inherited from SmoObjectBase.) |
![]() | Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.) |
![]() | UserData | Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
![]() | Alter() | Updates any changes with the security policy. |
![]() | Create() | Creates an object on the server as defined by the referenced SMO object. |
![]() | Deny(ObjectPermissionSet^, String^) | Denies access to the specified permission for the specified grantee on the SMO object. |
![]() | Deny(ObjectPermissionSet^, String^, Boolean) | Denies access to the specified permission for the specified grantee and other users that the grantee granted access on the SMO object. |
![]() | Deny(ObjectPermissionSet^, array<String^>^) | Denies permission to an object. |
![]() | Deny(ObjectPermissionSet^, array<String^>^, Boolean) | Denies permission to the specified object. |
![]() | Discover() | Discovers a list of type Object.(Inherited from SqlSmoObject.) |
![]() | Drop() | Drops the security policy object. |
![]() | DropIfExists() | Drops the SecurityPolicy object if exists. |
![]() | EnumObjectPermissions() | Enumerates a list of permissions for the security policy. |
![]() | EnumObjectPermissions(ObjectPermissionSet^) | Enumerates a list of object permissions for a specified permission on the security policy. |
![]() | EnumObjectPermissions(String^) | Enumerates a list of object permissions for a specified grantee on the SMO object. |
![]() | EnumObjectPermissions(String^, ObjectPermissionSet^) | Enumerates the specified set of permissions for the security policy. |
![]() | Equals(Object^) | (Inherited from Object.) |
![]() | FormatSqlVariant(Object^) | Formats an object as T: Microsoft.Data.Schema.Sql.DataGenerator.SqlVariant type.(Inherited from SqlSmoObject.) |
![]() | GetContextDB() | Gets the context database that is associated with this object.(Inherited from SqlSmoObject.) |
![]() | GetDBName() | Gets the database name that is associated with the object.(Inherited from SqlSmoObject.) |
![]() | GetHashCode() | (Inherited from Object.) |
![]() | GetPropValue(String^) | Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.) |
![]() | GetPropValueOptional(String^) | Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.) |
![]() | GetPropValueOptionalAllowNull(String^) | Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.) |
![]() | GetServerObject() | Gets the server of the SqlSmoObject object.(Inherited from SqlSmoObject.) |
![]() | GetType() | (Inherited from Object.) |
![]() | Grant(ObjectPermissionSet^, String^) | Grants access to the specified permission for the specified grantee on the security policy. |
![]() | Grant(ObjectPermissionSet^, String^, Boolean) | Grants the specified set of permissions to the grantees and the ability to grant the set of permissions to the security policy. |
![]() | Grant(ObjectPermissionSet^, String^, Boolean, String^) | Grants permission to the server. |
![]() | Grant(ObjectPermissionSet^, array<String^>^) | Grants permission for the object with the specified names. |
![]() | Grant(ObjectPermissionSet^, array<String^>^, Boolean) | Grants access to the specified permission and the ability to grant access to other users for the specified grantee on the SMO object. |
![]() | Grant(ObjectPermissionSet^, array<String^>^, Boolean, String^) | Grants permission for the object in the security policy. |
![]() | Initialize() | Initializes the object and forces the properties be loaded.(Inherited from SqlSmoObject.) |
![]() | Initialize(Boolean) | Initializes the object and forces the properties be loaded.(Inherited from SqlSmoObject.) |
![]() | IsObjectInitialized() | Verifies whether the object has been initialized.(Inherited from SqlSmoObject.) |
![]() | IsObjectInSpace() | Verifies whether the object is isolated or connected to the instance of SQL Server.(Inherited from SqlSmoObject.) |
![]() | IsSupportedProperty(String^) | Determines whether the specified property is supported in the target .NET Framework.(Inherited from SqlSmoObject.) |
![]() | Refresh() | Refreshes the script name.(Inherited from ScriptNameObjectBase.) |
![]() | Revoke(ObjectPermissionSet^, String^) | Revokes previously granted permissions from a grantee on the security policy object. |
![]() | Revoke(ObjectPermissionSet^, String^, Boolean, Boolean) | Revokes previously granted permission from a grantee on the SMO object and any other users to whom the grantee have granted access. The grantee are also given the ability to revoke other users' access. |
![]() | Revoke(ObjectPermissionSet^, String^, Boolean, Boolean, String^) | Revokes previously granted permissions from a grantees on the security policy object and any other users to whom the grantees have granted access. The grantees are also given the ability to revoke other users' access. |
![]() | Revoke(ObjectPermissionSet^, array<String^>^) | Revokes previously granted permission from a list of grantees on the SMO object. |
![]() | Revoke(ObjectPermissionSet^, array<String^>^, Boolean, Boolean) | Revokes previously granted permission from a grantees on the SMO object and any other users to whom the grantees have granted access. |
![]() | Revoke(ObjectPermissionSet^, array<String^>^, Boolean, Boolean, String^) | Revokes previously granted permissions from grantees on the database user and any other users to whom the grantees have granted access. |
![]() | Script() | Generates a string collection of script that can be used in the security policy. |
![]() | Script(ScriptingOptions^) | Generates a Transact-SQL script that can be used to re-create the SMO object as specified by the script options. |
![]() | SetParentImpl(SqlSmoObject^) | Sets the parent of the SqlSmoObject to the newParent parameter.(Inherited from SqlSmoObject.) |
![]() | ToString() | Returns a String that represents the referenced object.(Inherited from SqlSmoObject.) |
![]() | Validate(String^, array<Object^>^) | Validates the state of an object.(Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
![]() | PropertyChanged | Represents the event that occurs when a property is changed.(Inherited from SqlSmoObject.) |
![]() | PropertyMetadataChanged | Represents the event that occurs when property metadata changes.(Inherited from SqlSmoObject.) |
| Name | Description | |
|---|---|---|
![]() ![]() | IAlienObject::Discover() | Discovers any dependencies. Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.) |
![]() ![]() | IAlienObject::GetDomainRoot() | Returns the root of the domain.(Inherited from SqlSmoObject.) |
![]() ![]() | IAlienObject::GetParent() | Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.) |
![]() ![]() | IAlienObject::GetPropertyType(String^) | Gets the type of the specified property.(Inherited from SqlSmoObject.) |
![]() ![]() | IAlienObject::GetPropertyValue(String^, Type^) | Gets the value of the specified property.(Inherited from SqlSmoObject.) |
![]() ![]() | IAlienObject::GetUrn() | Gets the Unified Resource Name (URN) of the object. Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.) |
![]() ![]() | IAlienObject::Resolve(String^) | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object.(Inherited from SqlSmoObject.) |
![]() ![]() | IAlienObject::SetObjectState(SfcObjectState) | Sets the object state to the specified SfcObjectState value.(Inherited from SqlSmoObject.) |
![]() ![]() | IAlienObject::SetPropertyValue(String^, Type^, Object^) | Sets the property value.(Inherited from SqlSmoObject.) |
![]() ![]() | ISfcPropertyProvider::GetPropertySet() | Gets the interface reference to the set of properties of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.) |
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.





