模式在 sql server 中的重要性是什么? [英] What is the importance of schema in sql server?

问题描述

schema 在 sql server 中的重要性是什么?

What is the importance of schema in sql server?

这个模式对我有什么帮助?出于安全原因，这很重要吗?

Where this schema help me? Is it important for security reasons?

推荐答案

是的，SQL 模式的主要目的是 - 是 - 促进安全管理:定义谁 [哪些主体] 可以访问什么[哪些数据库对象].从 SQL 2005 开始，当架构不再直接绑定到所有者时，这变得特别容易.

Yes, the primary purpose of SQL schema was -is- to facilitate security management: define who [which principals] can access what [which database objects]. This was made particularly easier starting with SQL 2005 when the schema stopped being directly tied to the owner.

架构的另一个用途是用作命名空间，即防止来自不同架构的对象之间的名称冲突.
最初的用途是允许给定数据库的多个 [交互式，即临时类] 用户创建他们自己的表或存储过程(或其他对象)，而不必担心可能引入的类似命名对象的存在其他用户.
模式的类似命名空间的性质也可以用于计划的数据库设置中，即当单个架构师以提供不同类型的访问和实际上不同的行为的方式设计数据库结构时, 适用于不同的用户组.

Another use of schema is to serve as a namespace, that is preventing name clashes between objects from different schemas.
The original use of this was to allow multiple [interactive, i.e. ad-hoc like] users of a given database to create their own tables or stored procedures (or other objects), without having to worry about the existence of similarly named objects possibly introduced by other users.
The Namespace-like nature of schema can also be put to use in a planned database setting, i.e. one when a single architect designs the database structure in a way which provides distinct type of access, and indeed different behaviors, for distinct user groups.

这篇关于模式在 sql server 中的重要性是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！