보안 저장 프로시저(Transact-SQL)

Microsoft SQL Server 2005에서는 보안 관리에 사용되는 다음 시스템 저장 프로시저를 지원합니다.

sp_addalias	sp_droprolemember
sp_addapprole	sp_dropserver
sp_addgroup	sp_dropsrvrolemember
sp_addlinkedsrvlogin	sp_dropuser
sp_addlogin	sp_grantdbaccess
sp_addremotelogin	sp_grantlogin
sp_addrole	sp_helpdbfixedrole
sp_addrolemember	sp_helpgroup
sp_addserver	sp_helplinkedsrvlogin
sp_addsrvrolemember	sp_helplogins
sp_adduser	sp_helpntgroup
sp_approlepassword	sp_helpremotelogin
sp_changedbowner	sp_helprole
sp_changegroup	sp_helprolemember
sp_changeobjectowner	sp_helprotect
sp_change_users_login	sp_helpsrvrole
sp_dbfixedrolepermission	sp_helpsrvrolemember
sp_defaultdb	sp_helpuser
sp_defaultlanguage	sp_MShasdbaccess
sp_denylogin	sp_password
sp_dropalias	sp_remoteoption
sp_dropapprole	sp_revokedbaccess
sp_dropgroup	sp_revokelogin
sp_droplinkedsrvlogin	sp_setapprole
sp_droplogin	sp_srvrolepermission(Transact-SQL)
sp_dropremotelogin	sp_validatelogins

참고 항목