April 29, 2015 at 7:29 pm
Hi All,
Any idea how to give permission to someone to access database in SQL server without using SQL Management Studio ?
Thanks
April 29, 2015 at 7:45 pm
sqlcmd
SQL Server PowerShell
.NET + PowerShell
SMO + PowerShell
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 30, 2015 at 10:29 am
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.
April 30, 2015 at 7:38 pm
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