Proprietà JobStep.DatabaseUserName
Gets or sets the database user account that the job step assumes when executing the command string.
Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DatabaseUserName As String
Get
Set
'Utilizzo
Dim instance As JobStep
Dim value As String
value = instance.DatabaseUserName
instance.DatabaseUserName = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public string DatabaseUserName { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property String^ DatabaseUserName {
String^ get ();
void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DatabaseUserName : string with get, set
function get DatabaseUserName () : String
function set DatabaseUserName (value : String)
Valore proprietà
Tipo: System.String
A String value that specifies the name of the database user.
Osservazioni
A Microsoft SQL Server Agent job step can execute by assuming the rights of a database user. Change the DatabaseUserName property to set the user execution context for a job step. The default value is dbo, and job steps execute using database owner permissions.
Esempi
Pianificazione delle attività amministrative automatiche in SQL Server Agent
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo.Agent
Altre risorse
Automatizzazione delle attività amministrative (SQL Server Agent)