I have a SQL Server database that we are trying to make read-only for everyone except one user. I already went to properties>options>Database read-only = true and set the entire DB to read-only. Now we are finding that one program updates this DB and will not work correctly without being able to do so. Is there a way to leave the whole DB read-only and just grant write to this one single "user"? SQL server 2008 using SSMS 2017.
我有一个SQL Server数据库，我们试图为除一个用户以外的所有人提供只读权限。我已经去了属性> options> Database read-only = true并将整个DB设置为只读。现在我们发现一个程序更新了这个数据库，如果不能这样做就无法正常工作。有没有办法让整个数据库只读，只是授予这个单一的“用户”写入？使用SSMS 2017的SQL Server 2008。
1 个解决方案
#1
0
No, a database that is read-only cannot be written to by any user. You're best solution would be to give read only permissions to all users except this app.
不，任何用户都无法写入只读数据库。您最好的解决方案是为除此应用之外的所有用户提供只读权限。
#1
0
No, a database that is read-only cannot be written to by any user. You're best solution would be to give read only permissions to all users except this app.
不，任何用户都无法写入只读数据库。您最好的解决方案是为除此应用之外的所有用户提供只读权限。