Skip to content
English
Sign in
Customer Portal
  • There are no suggestions because the search field is empty.

When restoring a SQL DB, you may need to assign DBOWNER permissions to the DB

Here is a SQL query you can use to assign the needed permissions

DB name example:  SurePassDB_202x

DB User name example: SPUser_202x

USE SurePassSurePassDB_202x

GO

CREATE USER [SPUser_202x] FOR LOGIN [SPUser_202x] WITH DEFAULT_SCHEMA=[dbo]

GO

DECLARE @Username SYSNAME;

SET @Username = 'SPUser_202x'

EXEC sp_addrolemember N'db_datareader', @Username

EXEC sp_addrolemember N'db_datawriter', @Username

EXEC sp_addrolemember N'db_ddladmin', @Username

GO