Error:"user does not have pernission to perform this action.Change database context to 'DBName'"
I want t开发者_JS百科o execute "Create Login 'LoginName' with password='MyPass'" command but i recieve this error : "user does not have permission to perform this action.Change database context to 'DBName'".
how can i solve that?
You seem to be mission the permission to create a new login.
Check if the user has the permision to:
- ALTER ANY LOGIN
or
- ALTER LOGIN
More info here CREATE LOGIN (Transact-SQL)
精彩评论