JobStep.DatabaseUserName Property

Gets or sets the database user account that the job step assumes when executing the command string.

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DatabaseUserName As String 
    Get 
    Set
'Usage
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)

Property Value

Type: System.String
A String value that specifies the name of the database user.

Remarks

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.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

JobStep Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_help_jobstep (Transact-SQL)