Thanks Greg.But DBA who is having Sysadmin role will have the Security Priviliges like GRANT,REVOKE & DENY also.So our company wants to separte the tasks. Is it possible to have alternative roles to perform DBA tasks instead of Sysadmin role. correct me if am wrong.