Post reply

Data read/write permission

  • May 15, 2008 at 1:01 pm

    #125352

    I’ve 40 SQL 2005 DBs – I need to grant data read/write permission to windows users on all the user databases. Any such command exist ex. Grant select TO [domain\user] on ALL databases?

    Thanks

    ~J

  • May 15, 2008 at 1:08 pm

    #816112

    Nope.

    You could use sp_msforeachdb

    However, it is only 40 checkboxes in a single dialog, so I would just click them.

  • May 16, 2008 at 9:40 am

    #816603

    I get invalid object when I tried to execute sp_msforeachdb

    What would be input which I need to apply in this case?

    Msg 201, Level 16, State 4, Procedure sp_MSforeachdb, Line 0

    Procedure or function 'sp_MSforeachdb' expects parameter '@command1', which was not supplied

    Thanks

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

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