Difference between SQL Server and Oracle 'User'
Are there any differences between a user in SQL Server and one in Oracl开发者_Python百科e? If so, what are they?
In Oracle
, the users and the schema are one thing. You can create two different tables with the same name, belonging to different users.
In SQL Server
, schema and user are separate things. The users are only used to log in and define permissions.
See this question for more information: What is the difference between an Oracle and Microsoft schema?
Oracle schemas are like My Documents folders in the Windows OS. A user can grant permissions to other users to see things in their schema but an Oracle schema is essentially a user's workspace.
MS SQL Server's schemas are namespaces. While you can have Accounting and Marketing schemas, they are not tightly-coupled to individual users. Objects in an Accounting schema contain accounting information and objects in the Marketing schema have marketing information.
Oracle schemas are tightly-coupled to users and MS SQL Server schemas are primarily for classification.
精彩评论