Members of the db_securityadmin fixed database role can modify role membership and manage permissions.

 See Also

Reference

Database-Level Roles

Concepts

Permissions of Fixed Database Roles

Other Resources

sp_dbfixedrolepermission (Transact-SQL)
sp_helpdbfixedrole (Transact-SQL)
Security Considerations for Databases and Database Applications

Help and Information

Getting SQL Server 2005 Assistance