What are the minimum permissions necessary to use CREATE LOGIN?
I'm using db_accessAdmin and db_securityAdmin and db_owner. The user as access to the database.
It still says I can't create the login. What am I missing?
The answer is in Books Online:
http://msdn2.microsoft.com/en-us/library/ms189751.aspx
"Requires ALTER ANY LOGIN permission on the server. If the CREDENTIAL option is used, also requires ALTER ANY CREDENTIAL permission on the server."
Creating a login requires permissions at the server level, it cannot be accomplished with database level permissions.
Thanks
Laurentiu
No comments:
Post a Comment