The following database permissions are required to use the SQL database.

Rights:

• Connect
• Delete
• Execute
• Insert
• Select
• Update
• View definition

-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
 
USE [<DATABASE name,,>]
GO
IF NOT EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
BEGIN
  CREATE USER [<USER name,,>] FOR LOGIN [<USER name,,>]
END
GO
IF EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
GRANT CONNECT TO [<USER name,,>]
GO
IF EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
GRANT DELETE TO [<USER name,,>]
GO
IF EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
GRANT EXECUTE TO [<USER name,,>]
GO
IF EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
GRANT INSERT TO [<USER name,,>]
GO
IF EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
GRANT SELECT TO [<USER name,,>]
GO
IF EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
GRANT UPDATE TO [<USER name,,>]
GO
IF EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
GRANT VIEW DEFINITION TO [<USER name,,>]
GO

Rights:

• db_owner (role)

(or standard user rights + db_backupoperator)

-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
USE [<DATABASE name,,>]
GO
IF NOT EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
BEGIN
  CREATE USER [<USER name,,>] FOR LOGIN [<USER name,,>]
END
GO
IF EXISTS(SELECT s.[uid] FROM SYS.[sysusers] AS [s] WHERE [s].[name] ='<USER name,,>')
EXEC sp_addrolemember N'db_owner', N'<USER name,,>'
GO