SQL SERVER 2K5 schema vs. Oracle schema - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

SQL SERVER 2K5 schema vs. Oracle schema

SQL SERVER 2K5 schema vs. Oracle schema# Database - 数据库

M*r2006-08-16 07:08

1 楼

In SQL Server 2K5, schema is introduced.
Any comparison to Oracle's schema?
SQL Server 2K5:
Server
Database
Schema
Login -- User account
Oracle:
Server
Database
Schema -- User account
What's the benefit of adding the schema layer? Why it is not designed like
Oracle's? (I may have some mis-understanding for the concept)
Also, in SQL Server, login and user account are different? What the benefit?

M*r2006-08-16 07:08

2 楼

That's what I want to discuss:
Why Oracle doesn't implement it this way? Any Pros/Cons for different
implementation?
SQL Server now has 3 things:
User account
User login
Schema
While in Oracle, a database user account (commonly referred to as a schema)
is used to store database objects, applications, and components, and to
determine a user's database privileges.
Still confused by:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.mspx

,