Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Schema
Message
 
 
To
19/06/2001 17:41:41
General information
Forum:
Oracle
Category:
Other
Title:
Re: Schema
Miscellaneous
Thread ID:
00521226
Message ID:
00521228
Views:
19
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform