Post reply

dbowner permissions

  • November 30, 2012 at 7:22 am

    #265593

    how to provide dbowner permissions for all the databases to a user in sql ?

  • November 30, 2012 at 8:08 am

    #1564388

    try this:

    EXEC sp_MSForEachDB 'USE [?] CREATE USER [LOGIN_NAME_HERE] FOR LOGIN [LOGIN_NAME_HERE] EXEC sp_addrolemember N''db_owner'', N''LOGIN_NAME_HERE'''

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

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