Solved

SQL 2005

Posted on 2009-05-13
3
201 Views
Last Modified: 2012-05-06
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
Comment
Question by:SeTech
3 Comments
 
LVL 3

Expert Comment

by:Waynepre
ID: 24379055
0
 
LVL 5

Expert Comment

by:Aanvik
ID: 24379060
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
 
LVL 13

Accepted Solution

by:
St3veMax earned 500 total points
ID: 24379507
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now