>Hello everyone,
>I just want to confirm my understanding of a logical concept called 'schema' by getting some feedback from UniversalThread.
>
>In general schema is defined as the definition of an entire database. In oracle is used to define an user (scott/tiger). Is this correct?
>
>
>Thanks,
>Sergio
Yes. The Schema Name is really just the UserID used to connect to Oracle. However, it is usually an ID that reflects the name of the application and is not a real user. If the database was developed under the UserID of a real person [like an employee], then what do you do if/when that employee leaves? You are stuck leaving the database for your app under that employee's UserID [a bad idea] or moving the db to a new UserID [a real pain]. So, when we develop apps that use Oracle for the data, we create a
non-user UserID to create the database under. Then we create roles to define various access privileges on those objects. Then we grant appropriate roles to the real users.
Mark McCasland
Midlothian, TX USA