| User Name and Schema Name [message #57061] |
Sun, 18 May 2003 03:04  |
SK
Messages: 26
Registered: March 2001
|
Junior Member |
|
|
|
What is the difference between user name and schema name. What is the need of creating different oracle users where as we can create OS users and assign them the same schema.
|
|
|
|
| Re: User Name and Schema Name [message #57104 is a reply to message #57061] |
Tue, 20 May 2003 16:11  |
andy
Messages: 92
Registered: December 1999
|
Member |
|
|
The difference mostly lies in that a schema is a logical container that holds all the objects belonging to a particular user. I.e., if you have the correct privileges, you can access objects in another user's schema.
There are several reasons you may want separate users. For one, privileges (and auditing) can be set differently for each user. Also, changes made by each user are recorded in the online redo logs.
It is common for applications to enforce their own security and connect to the database as one user. Again, the problem is when you try to figure out who did what.
If you still want to user the same user for everyone, just make sure that you create a separate object-owning account. If you (and everyone else) log in as the object owner, you can drop any table you own.
HTH,
Andy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
