Security Stored Procedures in SQL Server 2005
Following Store Procedure are useful while manageing the 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
posted by Mahavir Sancheti at
3:49 AM
0 Comments:
Post a Comment
<< Home