give permission to someone

  • Hi All,

    Any idea how to give permission to someone to access database in SQL server without using SQL Management Studio ?

    Thanks

  • sqlcmd

    SQL Server PowerShell

    .NET + PowerShell

    SMO + PowerShell

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • You have to use a T-SQL command. That can be wrapped inside an SMO/PoSh script, but that's what's needed. Shawn has given you a few ways to do that, but ultimately you need a script of some sort.

    If you explain what you're trying to do, we can offer other suggestions.

    However, DO NOT grant users permissions. Always, always use a role.

  • Thanks for the reply ... appreciate !

    cheers mate

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply