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
Minium Permissions necessary to create a login?
Hot Topic
- xp_smtp_sendmail and Outlook Express works; Database Mail doesn't
- Implementing message queue in SQL Server 2000
- Anytime I connect to an Excel file from SSIS05, I start getting endemic system.outofmemoryexception errors and cannot save
- Error Msg 141 on Bulk Insert
- EXCEPTION_ACCESS_VIOLATION when installing June CTP
- QueryParameter Not passed to web service
- substring
- SQL Server 2005 Express and SQL Server 2005 Side-By-Side OK
- sdk for developing sql server front-end
- Excel 2003 and nonemptycrossjoin
SQL Server
- SQL CE Push ConnectTimeout
- Repair Corrupted MDF & LDF Files ????
- Using Custom Classes
- SQL 2005 Server Installation "Drop Location" Error
- Many-To-Many Self-Join
- Execute() in class Microsoft.SqlServer.Dts.RunTime.Package has memory leak
- Problem with Simple ScriptTask
- How to control CLR memory threshhold?
- Concurrent Insert and Update Commands
- WMI Event Watcher for Windows Monitoring Service
Minium Permissions necessary to create a login?
Joe Morel - MSFT
The answer is in Books Online:
http://msdn2.microsoft.com/en-us/library/ms189751.aspx
Creating a login requires permissions at the server level, it cannot be accomplished with database level permissions.
Thanks
Laurentiu