开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜