,PL/SQL tips-Tricks for error resolution version 2014,2012,2008,2005,Procedural language,Stored Procedure, computer , excel macro programming,Visual Studio,Film,Musical notations,Indian ,Western Music.

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.