home *** CD-ROM | disk | FTP | other *** search
/ PC World Komputer 1996 February / PCWK0296.iso / po7_win / db / rdbms71 / catdbsyn.sql < prev    next >
Encoding:
Text File  |  1994-08-07  |  5.5 KB  |  239 lines
  1. rem 
  2. rem $Header: catdbsyn.sql 7001200.1 92/11/03 17:29:06 twang Generic<base> $ 
  3. rem 
  4. Rem  Copyright (c) 1991 by Oracle Corporation 
  5. Rem    NAME
  6. Rem      dba_syn.sql - <one-line expansion of the name>
  7. Rem    DESCRIPTION
  8. Rem      <short description of component this file declares/defines>
  9. Rem    RETURNS
  10. Rem 
  11. Rem    NOTES
  12. Rem      <other useful comments, qualifications, etc.>
  13. Rem    MODIFIED   (MM/DD/YY)
  14. Rem     glumpkin   10/20/92 -  Renamed from DBA_SYN.SQL 
  15. Rem     mmoore     07/13/92 - #(118440) add dba_priv_audit_opts synonym 
  16. Rem     mmoore     07/06/92 -  change 'grants' to 'privs' in privilege views 
  17. Rem     rjenkins   04/24/92 -  adding snapshot views 
  18. Rem     mmoore     09/18/91 -  add dba_roles 
  19. Rem     rlim       08/22/91 - Creation - rename dba_synonyms.sql to dba_syn.sql
  20. Rem     rlim       07/30/91 -         added dba synonyms from catalog.sql & aud
  21. Rem   Kooi       03/11/91 - new stuff for procedures/triggers
  22. Rem   Moore      10/04/90 - add dba_col_grants
  23. Rem
  24. remark
  25. remark    NAME
  26. remark      DBA_SYNONYMS.SQL
  27. remark    FUNCTION
  28. remark      Creates private synonyms for DBA-only data dictionary views.
  29. remark    NOTES
  30. remark      Should be run in the account of every DBA user when created.
  31. remark    MODIFIED
  32. remark      Grayson    03/20/88 - Creation
  33. remark    Mendelsohn    05/11/89 - rename dba_exp_tables -> dba_exp_objects
  34. remark
  35. drop synonym DBA_CATALOG
  36. /
  37. create synonym DBA_CATALOG for SYS.DBA_CATALOG
  38. /
  39. drop synonym DBA_CLUSTERS
  40. /
  41. create synonym DBA_CLUSTERS for SYS.DBA_CLUSTERS
  42. /
  43. drop synonym DBA_CLU_COLUMNS
  44. /
  45. create synonym DBA_CLU_COLUMNS for SYS.DBA_CLU_COLUMNS
  46. /
  47. drop synonym DBA_COL_COMMENTS
  48. /
  49. create synonym DBA_COL_COMMENTS for SYS.DBA_COL_COMMENTS
  50. /
  51. drop synonym DBA_CROSS_REFS
  52. /
  53. create synonym DBA_CROSS_REFS for SYS.DBA_CROSS_REFS
  54. /
  55. drop synonym DBA_DATA_FILES
  56. /
  57. create synonym DBA_DATA_FILES for SYS.DBA_DATA_FILES
  58. /
  59. drop synonym DBA_DB_LINKS
  60. /
  61. create synonym DBA_DB_LINKS for SYS.DBA_DB_LINKS
  62. /
  63. drop synonym DBA_EXP_FILES
  64. /
  65. create synonym DBA_EXP_FILES for SYS.DBA_EXP_FILES
  66. /
  67. drop synonym DBA_EXP_OBJECTS
  68. /
  69. create synonym DBA_EXP_OBJECTS for SYS.DBA_EXP_OBJECTS
  70. /
  71. drop synonym DBA_EXP_VERSION
  72. /
  73. create synonym DBA_EXP_VERSION for SYS.DBA_EXP_VERSION
  74. /
  75. drop synonym DBA_EXTENTS
  76. /
  77. create synonym DBA_EXTENTS for SYS.DBA_EXTENTS
  78. /
  79. drop synonym DBA_FREE_SPACE
  80. /
  81. create synonym DBA_FREE_SPACE for SYS.DBA_FREE_SPACE
  82. /
  83. drop synonym DBA_INDEXES
  84. /
  85. create synonym DBA_INDEXES for SYS.DBA_INDEXES
  86. /
  87. drop synonym DBA_IND_COLUMNS
  88. /
  89. create synonym DBA_IND_COLUMNS for SYS.DBA_IND_COLUMNS
  90. /
  91. drop synonym DBA_OBJECTS
  92. /
  93. create synonym DBA_OBJECTS for SYS.DBA_OBJECTS
  94. /
  95. drop synonym DBA_SEQUENCES
  96. /
  97. create synonym DBA_SEQUENCES for SYS.DBA_SEQUENCES
  98. /
  99. drop synonym DBA_TAB_COLUMNS
  100. /
  101. create synonym DBA_TAB_COLUMNS for SYS.DBA_TAB_COLUMNS
  102. /
  103. drop synonym DBA_TAB_COMMENTS
  104. /
  105. create synonym DBA_TAB_COMMENTS for SYS.DBA_TAB_COMMENTS
  106. /
  107. drop synonym DBA_TAB_PRIVS
  108. /
  109. create synonym DBA_TAB_PRIVS for SYS.DBA_TAB_PRIVS
  110. /
  111. drop synonym DBA_ROLLBACK_SEGS
  112. /
  113. create synonym DBA_ROLLBACK_SEGS for SYS.DBA_ROLLBACK_SEGS
  114. /
  115. drop synonym DBA_SEGMENTS
  116. /
  117. create synonym DBA_SEGMENTS for SYS.DBA_SEGMENTS
  118. /
  119. drop synonym DBA_SYNONYMS
  120. /
  121. create synonym DBA_SYNONYMS for SYS.DBA_SYNONYMS
  122. /
  123. drop synonym DBA_TABLESPACES
  124. /
  125. create synonym DBA_TABLESPACES for SYS.DBA_TABLESPACES
  126. /
  127. drop synonym DBA_TABLES
  128. /
  129. create synonym DBA_TABLES for SYS.DBA_TABLES
  130. /
  131. drop synonym DBA_TS_QUOTAS
  132. /
  133. create synonym DBA_TS_QUOTAS for SYS.DBA_TS_QUOTAS
  134. /
  135. drop synonym DBA_USERS
  136. /
  137. create synonym DBA_USERS for SYS.DBA_USERS
  138. /
  139. drop synonym DBA_VIEWS
  140. /
  141. create synonym DBA_VIEWS for SYS.DBA_VIEWS
  142. /
  143. drop synonym DBA_COL_PRIVS
  144. /
  145. create synonym DBA_COL_PRIVS for SYS.DBA_COL_PRIVS
  146. /
  147. drop synonym DBA_TRIGGERS
  148. /
  149. create synonym DBA_TRIGGERS for SYS.DBA_TRIGGERS
  150. /
  151. drop synonym DBA_ROLE_PRIVS
  152. /
  153. create synonym DBA_ROLE_PRIVS for SYS.DBA_ROLE_PRIVS
  154. /
  155. drop synonym DBA_SYS_PRIVS
  156. /
  157. create synonym DBA_SYS_PRIVS for SYS.DBA_SYS_PRIVS
  158. /
  159. drop synonym DBA_CONSTRAINTS
  160. /
  161. create synonym DBA_CONSTRAINTS for SYS.DBA_CONSTRAINTS
  162. /
  163. drop synonym DBA_CONS_COLUMNS
  164. /
  165. create synonym DBA_CONS_COLUMNS for SYS.DBA_CONS_COLUMNS
  166. /
  167. drop synonym DBA_OBJ_AUDIT_OPTS
  168. /
  169. create synonym DBA_OBJ_AUDIT_OPTS for SYS.DBA_OBJ_AUDIT_OPTS
  170. /
  171. drop synonym DBA_STMT_AUDIT_OPTS
  172. /
  173. create synonym DBA_STMT_AUDIT_OPTS for SYS.DBA_STMT_AUDIT_OPTS
  174. /
  175. drop synonym DBA_PRIV_AUDIT_OPTS
  176. /
  177. create synonym DBA_PRIV_AUDIT_OPTS for SYS.DBA_PRIV_AUDIT_OPTS
  178. /
  179. drop synonym DBA_AUDIT_TRAIL
  180. /
  181. create synonym DBA_AUDIT_TRAIL for SYS.DBA_AUDIT_TRAIL
  182. /
  183. drop synonym DBA_AUDIT_SESSION
  184. /
  185. create synonym DBA_AUDIT_SESSION for SYS.DBA_AUDIT_SESSION
  186. /
  187. drop synonym DBA_AUDIT_STATEMENT
  188. /
  189. create synonym DBA_AUDIT_STATEMENT for SYS.DBA_AUDIT_STATEMENT
  190. /
  191. drop synonym DBA_AUDIT_OBJECT
  192. /
  193. create synonym DBA_AUDIT_OBJECT for SYS.DBA_AUDIT_OBJECT
  194. /
  195. drop synonym DBA_AUDIT_EXISTS
  196. /
  197. create synonym DBA_AUDIT_EXISTS for SYS.DBA_AUDIT_EXISTS
  198. /
  199. drop synonym DBA_2PC_PENDING
  200. /
  201. create synonym DBA_2PC_PENDING for SYS.DBA_2PC_PENDING
  202. /
  203. drop synonym DBA_2PC_NEIGHBORS
  204. /
  205. create synonym DBA_2PC_NEIGHBORS for SYS.DBA_2PC_NEIGHBORS
  206. /
  207. drop synonym DBA_DEPENDENCIES
  208. /
  209. create synonym DBA_DEPENDENCIES for SYS.DBA_DEPENDENCIES
  210. /
  211. drop synonym DBA_ERRORS
  212. /
  213. create synonym DBA_ERRORS for SYS.DBA_ERRORS
  214. /
  215. drop synonym DBA_OBJECT_SIZE
  216. /
  217. create synonym DBA_OBJECT_SIZE for SYS.DBA_OBJECT_SIZE
  218. /
  219. drop synonym DBA_SOURCE
  220. /
  221. create synonym DBA_SOURCE for SYS.DBA_SOURCE
  222. /
  223. drop synonym DBA_PROFILES
  224. /
  225. create synonym DBA_PROFILES for SYS.DBA_PROFILES
  226. /
  227. drop synonym DBA_ROLES
  228. /
  229. create synonym DBA_ROLES for SYS.DBA_ROLES
  230. /
  231. drop synonym DBA_SNAPSHOTS
  232. /
  233. create synonym DBA_SNAPSHOTS for SYS.DBA_SNAPSHOTS
  234. /
  235. drop synonym DBA_SNAPSHOT_LOGS
  236. /
  237. create synonym DBA_SNAPSHOT_LOGS for SYS.DBA_SNAPSHOT_LOGS
  238. /
  239.