| Computers Forum Index » Computer - Databases - Oracle (Server) » schema visibility... |
|
Page 1 of 1 |
|
| Author |
Message |
| student4life... |
 Posted: Wed Oct 14, 2009 7:17 pm |
|
|
|
Guest
|
Could someone tell me if person A adds one column to a table in the
database in person A's schema, will person B see the change from
person B's schema in the same database? TIA |
|
|
| Back to top |
|
|
|
| Malcolm Dew-Jones... |
| Posted: Wed Oct 14, 2009 11:34 pm |
|
|
|
Guest
|
student4life (student4lifer at (no spam) gmail.com) wrote:
: Could someone tell me if person A adds one column to a table in the
: database in person A's schema, will person B see the change from
: person B's schema in the same database? TIA
Lets call person A's table simply table A for simplicity.
If person B is allowed to see table A then they will see any changes to
the table.
However person B might _thinbk_ they are looking at table A but actually
be looking at a synonym of something else, such as a view that restricts
what they can see in table A. Then they won't see any changes to "A"
because it isn't actually table A they are looking at.
$0.10 |
|
|
| Back to top |
|
|
|
|
