신한 InsideBankNew

-- database생성
use [master]

IF NOT EXISTS
(SELECT * FROM sys.databases WHERE database_id = DB_ID(N'insidebankdb'))
BEGIN
EXEC sp_attach_db @dbname = N'insidebankdb',
@filename1 = N'C:\ShinhanBank\InsideBankNew\DB\insidebankdb.mdf',
@filename2 = N'C:\ShinhanBank\InsideBankNew\DB\insidebankdb_log.ldf';
END

use [insidebankdb]

-- insuser 로그인생성
create login [insuser] with password=N'tlsgks12#$!',default_database=[insidebankdb], default_language=[한국어],
check_expiration=off, check_policy=on;

-- insuser에 대한 sysadmin 권한부여
exec sys.sp_addsrvrolemember @loginame = N'insuser', @rolename = N'sysadmin';

-- 데이터베이스 복구모델 단순으로 변경
ALTER DATABASE [insidebankdb] SET RECOVERY SIMPLE

-- insidebankdb에 사용자(로그인)추가
exec sp_grantdbaccess 'insuser';

-- insuser에 db_owner 권한추가
exec sp_addrolemember 'db_owner', 'insuser';

-- insuser에 대한 sysadmin 권한삭제
exec sys.sp_dropsrvrolemember 'insuser', 'sysadmin';

-- 데이터베이스 매핑
exec sp_change_users_login 'UPDATE_ONE', 'insuser', 'insuser'