🚀 go-pugleaf

ԭ������ij�ű��µ�security
��Ȼ��schema
�������BOL��ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ba06f43a-a6a6-48
e3-886a-707fe4226858.htm ����msdn��schemas [SQL Server]���õ���
What is a schema?
A schema is a collection of database entities that form a single namespace. 
For example, to avoid name collisions, no two tables in the same schema can 
have the same name. Two tables can have the same name only if they are in 
separate schemas. 

Benefits of User �C Schema Separation
The abstraction of database users from schemas provides several benefits to 
administrators and developers.

Multiple users can own a single schema via membership in roles or Windows 
groups. This extends the familiar functionality allowing roles and groups 
to own objects.


Dropping database users is greatly simplified.


Dropping a database user does not require the renaming of objects 
contained by that user's schema. Thus it is no longer necessary to revise 
and test applications that refer explicitly to schema-contained objects 
after dropping the user that created them.


Multiple users can share a single default schema for uniform name 
resolution.


Shared default schemas allow developers to store shared objects in a 
schema created specifically for a specific application, rather than in the 
DBO schema. 


Permissions on schemas and schema-contained objects can be managed with a 
higher degree of granularity than in earlier releases.


Fully-qualified object names now have four parts: 
server.database.schema.object.
  �� �� MyLady ( ȥ������) �Ĵ�
�����ᵽ: ��: sql server express 2005 ��: ����ܹ���Ӧ���������ڱ�����ֵ�ǰ׺
: ����:dbo.table1
: dbo����һ���ܹ���
: �� �� Dem �Ĵ������ᵽ: ��
: : ����������ʲô�汾������
: : �ҵ�developer����security��ֻ��logins/server roles/credentials���������IJ�
: : һ����
: : ������ȥ���BOL


--
I thought what I'd do was, I'd pretend I was one of those deaf-mutes
Or should I?

You know what I��d like to be? I mean if I had my goddam choice, I��d just be
the catcher in the rye and all.

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.51.51]