Geek Answers Handbook

Using SQL Server Schemas

It seems to me that schemas are mainly intended for organizing tables, views, stored procedures, etc. in the SQL Server database. Can schemes play a big role (possibly in the field of database security, storage, etc.)?

Some clarification: I mean the "object" schemes. Sorry for the confusion.

Thanks.

+4
source share
3 answers

Check this link http://technet.microsoft.com/en-us/library/dd283095.aspx . It covers security aspects in the topic "Using schemas in SQL Server."

amuses

+3
source

Charts allow you to group tables for security and / or conceptual sanity. A group can be a department, a specific application area, an Active Directory group, a db role, etc.

If you have a table group that only your HR security group needs access to, you can create them within the HR scheme and enforce privileges from there.

If you have an application, you can create schemes for Sales, Content and Products only to separate the parts of the application.

+3
source

From an OO perspective, a database schema can be thought of as a class; with the database itself representing an instance of an object of this class.

The same applies to this analogy (re: security, memory usage, etc.)

-1
source

More articles:


All Articles