当前位置: 动力学知识库 > 问答 > 编程问答 >

SQL Server: permissions to read database diagrams for user that has 'read-only' access

问题描述:

Here I asked what are permissions to read database diagrams:

SQL Server: permissions to read database diagrams

Suggested answer is "db_owner" role... But in this case user will OWN DB.

Is it possible to provide read-only access to DB without granting any kind of 'update/modify' rights?

Thanks.

网友答案:

If you are asking whether a user can be the owner of a database and yet not be able to modify the data contained in any way (i.e. insert, update, delete), the answer is no. The closest you could get it to flag the entire database as read-only, and even then the owner could always change it back to read/write.

分享给朋友:
您可能感兴趣的文章:
随机阅读: