提供对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屋!