我正在准备一组视图,用户可以使用这些视图来准备自己的报告。视图从包括dbo在内的其他模式中查询表。视图是在单独的报告架构中创建的。我配置了以下用户,最终用户将使用该用户访问数据:
CREATE ROLE report AUTHORIZATION db_securityadmin;
GRANT SELECT, EXECUTE ON SCHEMA :: reporting TO report
CREATE LOGIN reporting_login WITH PASSWORD = 'SomePassword'
CREATE USER reporting_usr FOR LOGIN
根据这个网站的定义,可组合的架构是: https://www.hpe.com/us/en/what-is/composable-infrastructure.html In composable infrastructure, compute, storage, and networking resources are abstracted
from their physical locations,and can be managed by software, through a web-based interface.
Composable infrastructure makes