This is the second-best answer. Although true by default, you can GRANT other users access to your tables. Anyway, this would not help you make sure your table name was unique.
Tables are stored centrally in the DBMS, not on each user's disk space. Even so, it would not have helped you ensure that your tables have a unique name.
I made this up. The DBA can control access and permissions to tables which exist, not ones which may exist in the future.
Table names are automatically added to the start of tablenames you specify, so that "tablea" would become "jbloggs.tablea", provided your username was jbloggs. This helps you use your own tablenames locally, without having to worry to much about other users.
If this was true, how would you find out the name of the table you just created? It would be highly inconvenient, especially if the creation of the table was just part of a larger SQL program.
- Table names are only viewable by the person who created them.
- Tables are stored on each user's own disk space.
- The DBA can make creating tables with certain strings in the name password protected.
- Table names have their creator's user name prepended to the table name.
- A table created with the same name as another table is automatically renamed to make it unique.
| ||||
| ||||
|