Post reply

Assigning permission

  • December 3, 2008 at 1:21 am

    #92836

    Hi,

    I want to assign Execute permission of sp_adduser to a role and further to a user.

    I can able to do it successfully but when the user tries to execute the procedure getting error 'User doesnt have the permission'

    Since its one of the permissions of SYSADMIN role do i need to consider any other.

    Kindly some of you let me know.

    Thanks & Regards

    MAnjula

  • December 3, 2008 at 6:48 am

    #906823

    Instead of granting exec permissions on sp_adduser you can better use the fixed database role db_accessadmin to allow them to add new users. Eventually you also need db_securityadmin because that's necessary to grant permissions.

    [font="Verdana"]Markus Bohse[/font]

  • December 3, 2008 at 7:01 am

    #906835

    Thanks for the reply.

    But if I grant db_acessadmin and db_securityadmin roles ,user will get incorporated other permissions also.Hence I want the user has the privilege to execute sp_adduser only.

    Regards

    MAnjula

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply