我可以从SQL服务器删除sa登录吗? [英] Can I remove sa login from SQL server?
问题描述
我是数据库字段的初学者,这个问题可能听起来太愚蠢,但我想知道为什么有一个登录名为sa,我可以删除吗?
I am a beginner in database field and this question might sound too stupid but I want to know why there is a login called sa and can I delete it?
我想删除它,因为它似乎对数据库服务器有相当严重的特权!
I want to delete it because it seems to have pretty serious privileges on database server!
如果重要,我使用SQL Server Express 2008。
If it matters, I am using SQL Server Express 2008.
推荐答案
您不能删除 sa
帐户,但您可以重命名和/或停用。可以说这是好的做法,否则你有一个已知的用户名,攻击者可以发起强力的密码攻击。
You can't remove the sa
account but you can rename and/or disable it. Arguably this is good practice as otherwise you have a known username that an attacker could launch a brute force password attack against.
只要确保你禁用 sa
帐户,您拥有另一个具有管理员权限的帐户。
Just make sure if you disable the sa
account that you have another account with administrator privileges.
这篇关于我可以从SQL服务器删除sa登录吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!