提供对SQL表或视图的第三方访问 [英] Provide 3rd Party Access to a SQL Table or View

问题描述

我们为客户维护一个主数据存储库，并且需要与其他供应商共享数据.我不想让他们访问整个数据库，所以有什么办法可以将数据库用户限制为特定的表或视图?

We maintain a master data repository for our client and need to share data with another of their vendors. I don't want to provide them access to the full database, so is there a way I can constrain a database user to a specific table or view?

我考虑的一件事是用一个表创建一个单独的数据库，该表将同步到主数据库，然后让其他供应商访问该数据库，但是还有更好的方法吗?

One thing I considered is creating a separate database with a single table that would sync to the master database and then give the other vendor access to that database, but is there a better way?

预先感谢！

推荐答案

我们为客户维护一个主数据存储库，并且需要与其他供应商共享数据.我不想让他们访问整个数据库，所以有什么办法可以将数据库用户限制为特定的表或视图?

We maintain a master data repository for our client and need to share data with another of their vendors. I don't want to provide them access to the full database, so is there a way I can constrain a database user to a specific table or view?

我考虑的一件事是用一个表创建一个单独的数据库，该表将同步到主数据库，然后让其他供应商访问该数据库，但是还有更好的方法吗?

One thing I considered is creating a separate database with a single table that would sync to the master database and then give the other vendor access to that database, but is there a better way?

提前谢谢！

美好的一天<?！?>

Good day <?!?>

这基本上类似于本地SQL Server.您可以在服务器或数据库级别的几乎任何实体上授予权限，例如表，视图，表值函数，存储过程，扩展存储过程，标量函数，聚合函数，服务 队列或同义词.

This is basically like On-Prem SQL Server. You can grants permissions on almost any entity in the server or database level like a table, view, table-valued function, stored procedure, extended stored procedure, scalar function, aggregate function, service queue, or synonym.

请检查此文档是否满足您的需求:
https://docs.microsoft .com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql

Please check if this document cover your needs:
https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql

这篇关于提供对SQL表或视图的第三方访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！