Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Difference between SQL Server and Oracle 'User'

Are there any differences between a user in SQL Server and one in Oracle? If so, what are they?

like image 338
BeginnerAmongBeginners Avatar asked May 11 '10 14:05

BeginnerAmongBeginners


1 Answers

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?

like image 82
Quassnoi Avatar answered Sep 20 '22 12:09

Quassnoi