Project:
| View Revisions: Issue #34646 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0034646: Comments should be queried from user tables | ||
| Revision | 2016-11-28 12:23 by caristu | ||
| Description | Comments used to keep db consistency in Oracle are currently being stored in the following tables: ALL_TAB_COMMENTS[1] and ALL_COL_COMMENTS [2]. Therefore, users within the same DB can see the comments stored in those tables event if they are not the owners of the comment. This can cause errors when using the comments to update/export the database as comments from other users could be retrieved instead of the expected ones. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm [^] [2] https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1036.htm#REFRN20040 [^] |
||
| Revision | 2016-11-28 12:23 by caristu | ||
| Description | Comments used to keep db consistency in Oracle are currently being stored in the following tables: ALL_TAB_COMMENTS[1] and ALL_COL_COMMENTS [2]. Therefore, users within the same DB can see the comments stored in those tables event if they are not the owners of the comment. This can cause errors when using the comments to update/export the database as comments from other users could be retrieved instead of the expected one. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm [^] [2] https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1036.htm#REFRN20040 [^] |
||
| Revision | 2016-11-28 12:18 by caristu | ||
| Description | Comments used to keep db consistency are currently being stored in the following tables: ALL_TAB_COMMENTS[1] and ALL_COL_COMMENTS [2]. Therefore, users within the same DB can see the comments stored in those tables event if they are not the owners of the comment. This can cause errors when using the comments to update/export the database as comments from other users could be retrieved instead of the expected one. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm [^] [2] https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1036.htm#REFRN20040 [^] |
||
| Revision | 2016-11-28 12:16 by caristu | ||
| Description | Comments used to keep db consistency are currently being stored in the following tables: ALL_TAB_COMMENTS[1] and ALL_COL_COMMENTS [2]. Therefore, users within the same DB can see the comments stored in those tables event if they are not the owners of the comment. This can cause errors when using the comments to update/exporte the database as there is not a fixed criteria to retrieve the comments. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm [^] [2] https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1036.htm#REFRN20040 [^] |
||
| Revision | 2016-11-28 12:16 by caristu | ||
| Description | Comments used to keep db consistency are currently being stored in the following tables: ALL_TAB_COMMENTS[1] and ALL_COL_COMMENTS [2]. Therefore, users within the same DB can see the comments stored in those tables event if they are not the owners of the comment. This can cause errors when using the comments to update/exporte the database as there is not a fixed criteria to retrieve the comments. [1] https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm [^] [2] https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1036.htm#REFRN20040 [^] |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |