M*****r 发帖数: 1536 | 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*****r 发帖数: 1536 | 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
, |
|