Post reply

WITH GRANT OPTION

  • February 17, 2010 at 8:35 am

    #386327

    I've created a User and assigned him to ONE certain database with DBO_owner.

    This User needs the "WITH GRANT OPTION" permission.

    Is there a way to GRANT the User the "WITH GRANT OPTION" permission on this one database or do I have to do a GRANT for every object individually?

  • February 17, 2010 at 10:02 am

    #1120221

    As per MSDN...

    Members of the db_owner or db_securityadmin roles can grant any permissions on any statement or object in their database.

    So I do not think you need to do anything else. That user that you created as DB_OWNER already has the rights to do what ever they want on that database.

    -Roy

  • February 17, 2010 at 10:04 am

    #1120224

    Thanks, Roy. That's what I thought, but the Developer is telling me no. I'll check with him again.

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

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