SQLServer2005新建用户

Standard
CREATE login testuser WITH password='123456'
USE mytest
CREATE USER testuser FOR login testuser

点击 mytest->安全性->用户。
双击testuser,在出现的界面右中”拥有的架构”,右下”角色成员”中都选上db_owner.
至此,建立的用户就成了该数据库的管理员了.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.