• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

SQL 2005

I read where you need to use a Schema for Security Mgt in SQL 2005. Can someone briefly explain that to me? I am confused as to whether I set up a Role or Schema to manage a group of users.
Thansk
0
SeTech
Asked:
SeTech
1 Solution
 
AanvikCommented:
schema are defined at db level . Like you can have multiple schema's to store different groups of tables... For example dbo, Arch (to store archived tables), etc.

Roles are attached with users and may have permission to different objects in database.

http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server 
0
 
St3veMaxCommented:
In a nutshell a schema is an object owner.

You create a schema; say SETech; Any object which you create would then becone SETech.tbl_MyTable.

It allows for a more granular approach to security.

HTH
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now