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