Post reply

control permission

  • September 3, 2010 at 9:36 am

    #239932

    Hi friends,

    I gave grant control permission to an approle, but the user executing this approle is not able to create any new procedures or execute the existing procedures..

    Do I need to give more permissions other than the control permission?

    Please help me..

    Thank you

  • September 3, 2010 at 10:32 am

    #1216279

    Is that the only permission you granted?

  • September 3, 2010 at 10:39 am

    #1216285

    Yes...

    I created the user in the database, so the user has just the connect permission and no other permissions for this user..

    Approle is granted control permission to the database. When the user executes this approle, I thought he should be able to do everything in the database. But he is unable to create procedures or execute stored procedures.... Isnt control permission enough?

    Or will assigning the dbo schema to this role fix this issue?? I'm not sure if there is a command to assign the dbo schema to this role.. Basically, this role should have full access to the database... please help ..

    Thank you so much for your help

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

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