MSSQL 계정 생성 및 권한

-- DB name : Test_db

-- 계정 : test_acc

 

--DB 단위로 부여

--권한 부여

GRANT SELECT TO [test_acc]

GRANT ALTER TO [test_acc]

GRANT DELETE TO [test_acc]

GRANT UPDATE TO [test_acc]

GRANT INSERT TO [test_acc]

GRANT CREATE TABLE TO [test_acc]

--권한 제거

DENY UPDATE TO [test_acc]

DENY DELETE TO [test_acc]

 

--스키마 단위로 부여

GRANT CONNECT TO test_acc AS [dbo]

GRANT SELECT TO test_acc AS [dbo]

GRANT DELETE TO test_acc AS [dbo]

GRANT UPDATE TO test_acc AS [dbo]

GRANT EXECUTE TO test_acc AS [dbo]

GRANT VIEW DEFINITION TO test_acc AS [dbo]

 

--지정 SP에 권한 부여

grant execute on sp_TEST_update to Test_Acc