Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #34646 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
Powered by Mantis Bugtracker