January 3, 2013

One Schema For Many Users in SQL

A schema is collection of database objects of a User.
That means once u create an user a logical space is assigned for the objects (and data) created by that user. Using the same user name/password we can have multiple sessions simultaneously.

Its like creating an account on a mail account and once a person has the password for it as many windows can be open for the same. so there is no limit for the no. of users to access the same schema as user is the other name of schema.

A user is someone who can connect to a database and optionally can own objects in the database. The objects a user owns are collectively called schema. A schema, on its part, is always bound to exactly one user. Because there is obviously a 1 to 1 relationship between a user and a schema, these two terms are often used interchangeable.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.