Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL 2005

Posted on 2009-05-13
3
Medium Priority
?
213 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 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 1500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

916 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