我可以从SQL服务器删除sa登录吗? [英] Can I remove sa login from SQL server?

查看:89
本文介绍了我可以从SQL服务器删除sa登录吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我是数据库字段的初学者,这个问题可能听起来太愚蠢,但我想知道为什么有一个登录名为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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆