Granting permissions to a login

• anoop.mig29

  SSCrazy

  Points: 2224

  More actions

  October 22, 2013 at 10:50 pm

  #284217

  Hi i want to grant select , execute and connect permissions to a (sql login)

  how to grant ??

  is below query correct

  grant select,execute,connect to [loginame]

  reagrds

  Anoop

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  October 23, 2013 at 2:32 am

  #1660816

  What happens when you try it (in a dev or test environment)?

• - Win

  Hall of Fame

  Points: 3006

  More actions

  October 24, 2013 at 3:11 am

  #1661180

  http://technet.microsoft.com/en-us/library/ms188371.aspx

  Cheers,
  - Win
  "Dont Judge a Book by its Cover"