SQLCMD and the permissions needed

• chapwolff

  SSC Enthusiast

  Points: 159

  More actions

  May 23, 2024 at 8:20 pm

  #4423607

  Hey all,

  Hopefully this is a simple question. I am trying to figure out what permissions are needed for an account to use SQLCMD. I understand sysadmin allows use of it, but we are trying to not grant this non-user account sysadmin. I have been googling and either I'm not using the right keywords or there isn't a direct answer out there. So I come and supplicate myself to the knowledge of the masses.

• frederico_fonseca

  SSCoach

  Points: 16154

  More actions

  May 23, 2024 at 9:23 pm

  #4423624

  you mean which one of these?

  • using xp_cmdshell from a stored proc
  • or use a SQL Job with a sqlcmd step
  • or just use sqlcmd on the command line

  and when you mean non-user account what do you mean by this? a service account that is not used interactively? or something else.

  and finally what does the account require to do with access to it?