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