• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regading terminology Schema & User

 
Vivek Alampally
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi
I wish to know the difference between schema & user. What I know is, if a user is created, the schema -where in all the database objects are stored - is automatically created. My actual question is can a user be able to create multiple schemas? I know he can be given respective privileges to access other user' s schemas.
I feel answer for this question varies with different DBMS's. So please mention the DBMS which you are referring to, along with SQL statements

Thanks
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34839
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vivek,
In Oracle, you need a user for each schema.

Since you asking about other databases, I'm going to move this from Oracle to JDBC. That way other databases can be discussed too.
 
sowmy raj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Barring the case of enterprise users, where users are defined outside the database and then multiple users can be assigned to a particular schema, the relationship between users and schemas is 1:1. A schema is the set of objects owned by a database user. A single database user, by definition, cannot own objects in different schemas.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic