grantpermission.sql

来自「Time Tracker Starter Kit 使您能轻松创建这样一个应用程序」· SQL 代码 · 共 18 行

USE master
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = '~~##CMRCStarterKitUser##~~')
BEGIN
    declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'us_english'
    if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
        select @logindb = N'master'
    if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
        select @loginlang = @@language
    exec sp_addlogin '~~##CMRCStarterKitUser##~~', '~~##CMRCUserPWD##~~', @logindb, @loginlang
END


USE ~~##CMRCStarterKitDB##~~
if not exists(select * from sysusers where name=N'~~##CMRCStarterKitUser##~~')
	EXEC sp_grantdbaccess N'~~##CMRCStarterKitUser##~~'
	
EXEC sp_addrolemember N'db_owner', N'~~##CMRCStarterKitUser##~~'