home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a524 / 33.ddi / admin / iadgrant.sql < prev    next >
Encoding:
Text File  |  1991-03-04  |  2.4 KB  |  118 lines
  1. rem
  2. rem $Header: iadgrant.sql,v 3001400.1 90/02/27 14:43:45 rcs Exp $ iadgrant.sql Copyr (c) 1989 Oracle
  3. rem
  4. rem SQLFORMS3030014,DUA50:[FREEZE_SQLFORMS30.SQL.30014]
  5. Rem Copyright (c) 1988 by Oracle Corporation
  6. Rem NAME
  7. Rem    IADGRANTS.SQL - Grant privileges and create synonyms on tables.
  8. Rem  FUNCTION
  9. Rem  NOTES
  10. Rem  MODIFIED
  11. Rem   Eicher     02/05/90 - Creation
  12. Rem   Eicher     02/05/90 - Renamed from iadgrants.sql, renamed spool file
  13. Rem   Fine       01/25/89 - TOUCH
  14. Rem   Hsi        08/31/88 - Change tables' name
  15. Rem   Hsi        08/31/88 - Creation
  16. Rem
  17. spool iadgrant.lis
  18. grant select, insert, update, delete
  19. on    system.form_app
  20. to    public
  21. /
  22. grant select, insert, update, delete
  23. on    system.form_blk
  24. to    public
  25. /
  26. grant select, insert, update, delete
  27. on    system.form_fld
  28. to    public
  29. /
  30. grant select, insert, update, delete
  31. on    system.form_page
  32. to    public
  33. /
  34. grant select, insert, update, delete
  35. on    system.form_map
  36. to    public
  37. /
  38. grant select, insert, update, delete
  39. on    system.form_sqltxt
  40. to    public
  41. /
  42. grant select, insert, update, delete
  43. on    system.form_trg
  44. to    public
  45. /
  46. grant select, insert, update, delete
  47. on    system.form_trigger
  48. to    public
  49. /
  50. grant select, insert, update, delete
  51. on    system.form_comment
  52. to    public
  53. /
  54. grant select, insert, update, delete
  55. on    system.form_reference
  56. to    public
  57. /
  58. grant select, insert, update, delete
  59. on    system.form_procedure
  60. to    public
  61. /
  62. drop public synonym form_app
  63. /
  64. create public synonym form_app
  65. for    system.form_app
  66. /
  67. drop public synonym form_blk
  68. /
  69. create public synonym form_blk
  70. for    system.form_blk
  71. /
  72. drop public synonym form_fld
  73. /
  74. create public synonym form_fld
  75. for    system.form_fld
  76. /
  77. drop public synonym form_page
  78. /
  79. create public synonym form_page
  80. for    system.form_page
  81. /
  82. drop public synonym form_map
  83. /
  84. create public synonym form_map
  85. for    system.form_map
  86. /
  87. drop public synonym form_sqltxt
  88. /
  89. create public synonym form_sqltxt
  90. for    system.form_sqltxt
  91. /
  92. drop public synonym form_trg
  93. /
  94. create public synonym form_trg
  95. for    system.form_trg
  96. /
  97. drop public synonym form_trigger
  98. /
  99. create public synonym form_trigger
  100. for    system.form_trigger
  101. /
  102. drop public synonym form_comment
  103. /
  104. create public synonym form_comment
  105. for    system.form_comment
  106. /
  107. drop public synonym form_reference
  108. /
  109. create public synonym form_reference
  110. for    system.form_reference
  111. /
  112. drop public synonym form_procedure
  113. /
  114. create public synonym form_procedure
  115. for    system.form_procedure
  116. /
  117. spool off
  118.