Results 1 to 2 of 2

Thread: roles

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: roles

    I have a server A and databases A1,A2,A3,A4,A5,A6.How to give a db_owner permission to all the server(i,e on A)

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    exec master.dbo.sp_MSForeachdb 'use ? exec sp_addrolemember ''db_owner'',''HackTester'''

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •