如何在没有管理员用户的情况下访问数据库(例如标准用户或其他管理员用户)
问题描述:
你好,
我在Windows管理员用户中具有数据库,并且在Windows 7中具有一个标准用户来访问同一数据库,但该标准数据库无法访问该数据库.只有该管理员用户才能访问该数据库.
如果我已将用户映射赋予数据库的内置用户,则Windows7的任何用户都可以访问该数据库,否则不能访问
我该如何解决这个问题?
在此先感谢
Dhammaratna
Hello,
i have database in windows administrator user and i have one standard user in windows 7 to access same database but that database is not accessible for that standard database.only that administrator user can access that database.
if i have given user mappings to built in user of my database then any user of windows7 can access that database otherwise not
How can i solve this problem?
Thanks in advance
Dhammaratna
答
尝试通过添加SQL数据库登录名(仅登录名类似于 域)来仅授予用户权限\ User 具有Windows身份验证.然后在用户映射下授予用户权限.
Try giving only the user rights by adding a SQL database login where the Login Name is like Domain\User with windows authentication. Then give the user permissions under User Mappings.