Security stored procedures (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
SQL Server supports the following system stored procedures that are used to manage security. Some of these stored procedures are deprecated, but continue to be available to support backward compatibility. The topics for deprecated procedures will list their replacement.
sp_addapprole (Deprecated)
sp_addlogin (Deprecated)
sp_addremotelogin (Deprecated)
sp_addrole (Deprecated)
sp_addrolemember (Deprecated)
sp_addserver (Deprecated)
sp_addsrvrolemember (Deprecated)
sp_adduser (Deprecated)
sp_approlepassword (Deprecated)
sp_change_users_login (Deprecated)
sp_changedbowner (Deprecated)
sp_changeobjectowner (Deprecated)
sp_dbfixedrolepermission (Deprecated)
sp_defaultdb (Deprecated)
sp_defaultlanguage (Deprecated)
sp_denylogin (Deprecated)
sp_dropalias (Deprecated)
sp_dropapprole (Deprecated)
sp_droplogin (Deprecated)
sp_dropremotelogin (Deprecated)
sp_droprole (Deprecated)
sp_droprolemember (Deprecated)
sp_dropsrvrolemember (Deprecated)
sp_dropuser (Deprecated)
sp_grantdbaccess (Deprecated)
sp_grantlogin (Deprecated)
sp_helpremotelogin (Deprecated)
sp_helprotect (Deprecated)
sp_helpuser (Deprecated)
sp_password (Deprecated)
sp_remoteoption (Deprecated)
sp_revokedbaccess (Deprecated)
sp_revokelogin (Deprecated)
sp_srvrolepermission (Deprecated)
Related content
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre