SQL Server 2005中的数据库限制 [英] Database restriction in sql server 2005

问题描述

如何限制我的数据库查看其他用户?
创建数据库时，将设置用户ID或密码，而当我想访问数据库时，将显示一条消息以接受用户ID和密码..

How can I restrict my database to view other user?
when database is created a user id or password will set and while i want to access my database, a message will display to accept the user id and password..

推荐答案

您要限制使用SQL代理作业的数据库用户，换句话说，数据库用户应该不能访问/查看/启动SQL代理作业.
是吗?
这里有一些建议..i之所以可以在此站点中为您推荐，是因为
有一些误解.
一些解决方案在此处

You want to restrict your Database Users using the SQL Agent Jobs, in other words database user should not able to access / see /start the SQL Agent Jobs.
Is that right?
here are some advise..i can refer you in this site because
there''re some misunderstanding with question.
some of the solution are in here

这篇关于SQL Server 2005中的数据库限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！