Re: minimum permissions to grant / delete logins

Chris
A user needs ALTER ANY LOGIN to create or delete logins.
When you say> if the
user only has permissions to the database for my app<<. do you mean an
access to ther database?

In SQL Server 2005, you can use the Has_Perms_By_Name() function
(http://msdn2.microsoft.com/en-us/library/ms189802.aspx).







"Chris" <cbtechlists@xxxxxxxxx> wrote in message
news:084578f8-b46b-4e4c-a1b5-cdc11f69d40d@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm creating an admin tool for the app I'm working on and I want to be
able to grant the business admin user the ability to create logins,
and delete logins; >>but only allow them to delete the login if the
user only has permissions to the database for my app<<.

What are the minimum permissions I need to grant to the business admin
user for this?

Thanks!


.