Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Schema
Message
 
 
À
19/06/2001 17:41:41
Sergio Ortiz
Tek Services Group, Llc
Hollywood, Floride, États-Unis
Information générale
Forum:
Oracle
Catégorie:
Autre
Titre:
Re: Schema
Divers
Thread ID:
00521226
Message ID:
00521228
Vues:
20
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform