Hi, just few hours ago we started an internal project named: SAP DB systemtables which will think about our systemtables, the naming, the info returned, the privileges, all that stuff. During this project we will, of course, check the behaviour mentioned below.
By now, I have no idea what the result of this project will be. But it will not work for version 7.3, that is the only point, which is clear by now. Thank you for reporting the list. (Otherwise, I am afraid, it was my duty to prepare that list) Elke SAP Labs Berlin Blas Rodriguez Somoza wrote: > Recently I discover that it is possible to delete records > from some > system tables that stores information about tables, columns etc. > > The way I discover that is with a utility that empties > database tables. > It is a universal tool, and so it don't know about system tables. > > This is the list of the tables for which the db allow to > delete records. > There are at least one table that the system must not allow to empty > SYSODBCTYPES. > > I don't know what each table are used for, and I can't > find anything in > the docs, but I suspect the problem exists with other tables, > for instance > DBPARAMSINFO, so I include the entire list. > > Delete records Table:CNHIST OK > Delete records Table:CNMEDDEF OK > Delete records Table:CNMEDIA OK > Delete records Table:CNREPRT OK > Delete records Table:CNSTATE OK > Delete records Table:DBANALYZER OK > Delete records Table:DBANALYZER_ADMIN OK > Delete records Table:DBPARAMSINFO OK > Delete records Table:HELP OK > Delete records Table:MESSAGES OK > Delete records Table:PRESENT OK > Delete records Table:PRESENT_R OK > Delete records Table:PRESENT_W OK > Delete records Table:PRINT OK > Delete records Table:PRINT_W OK > Delete records Table:PRINT_R OK > Delete records Table:QUERYLIB OK > Delete records Table:QUERYLIBRARY OK > Delete records Table:QUERY_GRANT OK > Delete records Table:QUERY_CALL OK > Delete records Table:QUERY_OWN OK > Delete records Table:QU_USR_ACCS_QCM OK > Delete records Table:QUHIST OK > Delete records Table:QUHISTORY OK > Delete records Table:SET OK > Delete records Table:SET_R OK > Delete records Table:SET_W OK > Delete records Table:SYS_AUTOSUPPOSE OK > Delete records Table:SYS_UPDSTATISTICS OK > Delete records Table:SYS_MYAUTOSUPPOSE OK > Delete records Table:SYSACCOUNT OK > Delete records Table:SYSBU$MEDIA OK > Delete records Table:SYSBU$REPORT OK > Delete records Table:SYSBU$HISTORY OK > Delete records Table:SYSBU$STATE OK > Delete records Table:SYSCHECKTABLELOG OK > Delete records Table:SYSCMD_ANALYZE OK > Delete records Table:SYSDATA_ANALYZE OK > Delete records Table:SYSERRORMAP OK > Delete records Table:SYSMONDATA OK > Delete records Table:SYSMONITOR OK > Delete records Table:SYSODBCTYPES OK > Delete records Table:SYSPARSEID OK > Delete records Table:SYSPROFILE OK > Delete records Table:SYSQP_ALL_FAVORITES OK > Delete records Table:SYSQP_ALL_SHARED_OBJECTS OK > Delete records Table:SYSQP_ALL_USER_PROFILES OK > Delete records Table:SYSQP_ALL_OBJECTS OK > Delete records Table:SYSQP_TO_ME_SHARED_OBJECTS OK > Delete records Table:SYSQP_MY_FAVORITES OK > Delete records Table:SYSQP_MY_OBJECTS OK > Delete records Table:SYSQP_MY_OWN_SHARED_OBJECTS OK > Delete records Table:SYSQP_USER_PROFILES OK > Delete records Table:SYSSTATISTICS OK > Delete records Table:SYSUPDSTATWANTED OK > Delete records Table:SYSUPDSTATLOG OK > Delete records Table:WA_MY_CONTAINER OK > Delete records Table:WA_CONTAINER OK > Delete records Table:WA_MY_INODE OK > Delete records Table:WA_INODE OK > > Can't be deleted Table:CNDETAIL > Can't be deleted Table:CONFIGURATION > Can't be deleted Table:DATADEVSPACES > Can't be deleted Table:DB_STATE > Can't be deleted Table:DBPARAMETERS > Can't be deleted Table:DBTIMES > Can't be deleted Table:DUAL > Can't be deleted Table:ESTIMATED_PAGES > Can't be deleted Table:INTERNAL_STATE > Can't be deleted Table:INDEXPAGES > Can't be deleted Table:INDEXSTATISTICS > Can't be deleted Table:LOCKLISTSTATISTICS > Can't be deleted Table:LOCKSTATISTICS > Can't be deleted Table:MONITOR > Can't be deleted Table:MONITOR_CACHES > Can't be deleted Table:MONITOR_LOCK > Can't be deleted Table:MONITOR_ROW > Can't be deleted Table:MONITOR_PAGES > Can't be deleted Table:MONITOR_LONG > Can't be deleted Table:MONITOR_LOG > Can't be deleted Table:MONITOR_LOAD > Can't be deleted Table:MONITOR_TRANS > Can't be deleted Table:MONITOR_VTRACE > Can't be deleted Table:OPTIMIZERSTATISTICS > Can't be deleted Table:PAGES > Can't be deleted Table:ROOTS > Can't be deleted Table:RUNNING_COMMANDS > Can't be deleted Table:SERVERDBSTATISTICS > Can't be deleted Table:SYSQP_TO_ME_GRANTED_OBJECTS > Can't be deleted Table:SYSODBCTABLES > Can't be deleted Table:SYSODBCTABLEPRIVILEGES > Can't be deleted Table:SYSODBCINDEXSTAT > Can't be deleted Table:SYSODBCINDEXES > Can't be deleted Table:SYSODBCPROCCOLUMNS > Can't be deleted Table:SYSODBCPROCEDURES > Can't be deleted Table:SYSODBCTABLESTAT > Can't be deleted Table:SYSODBCCOLUMNS > Can't be deleted Table:SYSODBCCOLUMNPRIVILEGES > Can't be deleted Table:SYSODBCFOREIGNKEYS > Can't be deleted Table:TABLESTATISTICS > Can't be deleted Table:TRANSACTIONS > Can't be deleted Table:TREELOCKS > Can't be deleted Table:USERSTATISTICS > > Regards > Blas Rodriguez Somoza > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
