Application.SetPackageRoles 메서드
Sets the database roles that have read access and write access to the package. Database roles apply only to package stored in the SQL Server msdb database.
네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS(Microsoft.SqlServer.ManagedDTS.dll)
구문
‘선언
Public Sub SetPackageRoles ( _
serverName As String, _
packagePath As String, _
readerRole As String, _
writerRole As String _
)
‘사용 방법
Dim instance As Application
Dim serverName As String
Dim packagePath As String
Dim readerRole As String
Dim writerRole As String
instance.SetPackageRoles(serverName, _
packagePath, readerRole, writerRole)
public void SetPackageRoles(
string serverName,
string packagePath,
string readerRole,
string writerRole
)
public:
void SetPackageRoles(
String^ serverName,
String^ packagePath,
String^ readerRole,
String^ writerRole
)
member SetPackageRoles :
serverName:string *
packagePath:string *
readerRole:string *
writerRole:string -> unit
public function SetPackageRoles(
serverName : String,
packagePath : String,
readerRole : String,
writerRole : String
)
매개 변수
- serverName
유형: System.String
Specify the name and instance of the server that contains the package.
- packagePath
유형: System.String
Specify the name of the package.
- readerRole
유형: System.String
Specify a role to have read access.
- writerRole
유형: System.String
Specify a role to have write access.
예
The following code example shows how to set package roles, assuming the variables have been set to reflect your specific server name, package path, and roles.
app.SetPackageRoles(serverName, packagePath, readerRole, writerRole);
app.SetPackageRoles(serverName, packagePath, readerRole, writerRole)