Are there any differences between a user in SQL Server and one in Oracle? If so, what are they?
Thanks in advance.
+3
A:
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.
Quassnoi
2010-05-11 14:50:03
Additionally, what is a `schema` in Oracle is a `database` in SQL Server.
René Nyffenegger
2010-05-11 14:57:20
@René: `SQL Server` has a concept of `schema` too. In the three-part name `'mydb.dbo.mytable'`, `mydb` is a database (physical grouping), while `dbo` is a schema (logical grouping).
Quassnoi
2010-05-11 15:01:12