"Application role" (sp_setapprole ) support/example?

[gwideman]

Hi folks,

Are there any special features in SDAC to simplify working with SQL Server "application roles"? Any docs or examples of how to work with app roles?

Thanks,

Graham

[AndreyZ]

Hello,

You can use the TMSStoredProc component to work with application roles like this:

Code: Select all

  MSStoredProc.StoredProcName := 'sp_setapprole';
  MSStoredProc.Params.ParamByName('rolename').AsString := 'rolename';
  MSStoredProc.Params.ParamByName('password').AsString := 'password';
  MSStoredProc.Params.ParamByName('encrypt').AsString := 'encrypt';
  MSStoredProc.Execute;