Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Reload this Page Permissions required to create Database Login
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 19th, 2006, 02:06 AM
Registered User
  
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to mvsuresh01
Default Permissions required to create Database Login
Hi,
I want to know the Windows User Permissions required to create Database Login.
Can anybody help me?

Thanks,
Suresh
 
Old October 19th, 2006, 08:51 AM
SQLScott's Avatar
Wrox Author
  
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default
Someone can correct me on this, but I don't think there is a specific Windows permission. You might be referring to the ability to create a SQL Server login using Windows authentication. If that is the case, it follows the SQL Server permissions. When creating the login, you must specify the rights to that login to create other Database logins. Per BOL:

Requires ALTER ANY LOGIN permission on the server. If the CREDENTIAL option is used, also requires ALTER ANY CREDENTIAL permission on the server.

I hope this helps...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help - How to create a Login tracker? melvados Visual Basic 2005 Basics 3 August 4th, 2008 09:07 AM
How to create the login curiaquita VB.NET 4 June 4th, 2008 07:13 AM
Blog - Can login but, cannot create new entry j.t.w BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 13 January 24th, 2007 03:15 PM
database permissions marmer All Other Wrox Books 1 November 15th, 2004 09:46 AM
Please Help! Attempt to create a login page nvillare Classic ASP Basics 8 August 12th, 2003 09:06 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.