home *** CD-ROM | disk | FTP | other *** search
/ com!online 2002 April / comcd0402.iso / vollver / adabas / f_0001 / env / oraddrop.ins < prev    next >
Encoding:
Text File  |  1999-11-01  |  13.1 KB  |  831 lines
  1.  
  2. *   *ID* ORADDROP CMD      changed on 1994-05-18-11.38.43 by KRISCHAN  *
  3.  
  4. SQLMODE ADABAS
  5. *
  6. USE USER sys sys
  7. *
  8. SQLMODE oracle
  9. *
  10.  
  11. * Most of the user_* views are defined in terms of other dd-views, so
  12. * let's drop them first
  13. *
  14. IF $RC (SHOW VIEW user_audit_connect) = 0
  15. THEN
  16. *
  17.    DROP VIEW user_audit_connect
  18. *
  19. IF $RC (SHOW VIEW user_audit_object) = 0
  20. THEN
  21. *
  22.    DROP VIEW user_audit_object
  23. *
  24. IF $RC (SHOW VIEW user_audit_resource) = 0
  25. THEN
  26. *
  27.    DROP VIEW user_audit_resource
  28. *
  29. IF $RC (SHOW VIEW user_audit_session) = 0
  30. THEN
  31. *
  32.    DROP VIEW user_audit_session
  33. *
  34. IF $RC (SHOW VIEW user_audit_statements) = 0
  35. THEN
  36. *
  37.    DROP VIEW user_audit_statements
  38. *
  39. IF $RC (SHOW VIEW user_audit_trail) = 0
  40. THEN
  41. *
  42.    DROP VIEW user_audit_trail
  43. *
  44. IF $RC (SHOW VIEW user_catalog) = 0
  45. THEN
  46. *
  47.    DROP VIEW user_catalog
  48. *
  49. IF $RC (SHOW VIEW user_clu_columns) = 0
  50. THEN
  51. *
  52.    DROP VIEW user_clu_columns
  53. *
  54. IF $RC (SHOW VIEW user_clusters) = 0
  55. THEN
  56. *
  57.    DROP VIEW user_clusters
  58. *
  59. IF $RC (SHOW VIEW user_col_comments) = 0
  60. THEN
  61. *
  62.    DROP VIEW user_col_comments
  63. *
  64. IF $RC (SHOW VIEW user_col_grants) = 0
  65. THEN
  66. *
  67.    DROP VIEW user_col_grants
  68. *
  69. IF $RC (SHOW VIEW user_col_grants_made) = 0
  70. THEN
  71. *
  72.    DROP VIEW user_col_grants_made
  73. *
  74. IF $RC (SHOW VIEW user_col_grants_recd) = 0
  75. THEN
  76. *
  77.    DROP VIEW user_col_grants_recd
  78. *
  79. IF $RC (SHOW VIEW user_col_privs) = 0
  80. THEN
  81. *
  82.    DROP VIEW user_col_privs
  83. *
  84. IF $RC (SHOW VIEW user_col_privs_made) = 0
  85. THEN
  86. *
  87.    DROP VIEW user_col_privs_made
  88. *
  89. IF $RC (SHOW VIEW user_col_privs_recd) = 0
  90. THEN
  91. *
  92.    DROP VIEW user_col_privs_recd
  93. *
  94. IF $RC (SHOW VIEW user_cons_columns) = 0
  95. THEN
  96. *
  97.    DROP VIEW user_cons_columns
  98. *
  99. IF $RC (SHOW VIEW user_constraints) = 0
  100. THEN
  101. *
  102.    DROP VIEW user_constraints
  103. *
  104. IF $RC (SHOW VIEW user_cross_refs) = 0
  105. THEN
  106. *
  107.    DROP VIEW user_cross_refs
  108. *
  109. IF $RC (SHOW VIEW user_db_links) = 0
  110. THEN
  111. *
  112.    DROP VIEW user_db_links
  113. *
  114. IF $RC (SHOW VIEW user_extents) = 0
  115. THEN
  116. *
  117.    DROP VIEW user_extents
  118. *
  119. IF $RC (SHOW VIEW user_free_space) = 0
  120. THEN
  121. *
  122.    DROP VIEW user_free_space
  123. *
  124. IF $RC (SHOW VIEW user_ind_columns) = 0
  125. THEN
  126. *
  127.    DROP VIEW user_ind_columns
  128. *
  129. IF $RC (SHOW VIEW user_indexes) = 0
  130. THEN
  131. *
  132.    DROP VIEW user_indexes
  133. *
  134. IF $RC (SHOW VIEW user_obj_audit_opts) = 0
  135. THEN
  136. *
  137.    DROP VIEW user_obj_audit_opts
  138. *
  139. IF $RC (SHOW VIEW user_object_size) = 0
  140. THEN
  141. *
  142.    DROP VIEW user_object_size
  143. *
  144. IF $RC (SHOW VIEW user_objects) = 0
  145. THEN
  146. *
  147.    DROP VIEW user_objects
  148. *
  149. IF $RC (SHOW VIEW user_resource_limit) = 0
  150. THEN
  151. *
  152.    DROP VIEW user_resource_limit
  153. *
  154. IF $RC (SHOW VIEW user_role_privs) = 0
  155. THEN
  156. *
  157.    DROP VIEW user_role_privs
  158. *
  159. IF $RC (SHOW VIEW user_segments) = 0
  160. THEN
  161. *
  162.    DROP VIEW user_segments
  163. *
  164. IF $RC (SHOW VIEW user_sequences) = 0
  165. THEN
  166. *
  167.    DROP VIEW user_sequences
  168. *
  169. IF $RC (SHOW VIEW user_snapshot_logs) = 0
  170. THEN
  171. *
  172.    DROP VIEW user_snapshot_logs
  173. *
  174. IF $RC (SHOW VIEW user_snapshots) = 0
  175. THEN
  176. *
  177.    DROP VIEW user_snapshots
  178. *
  179. IF $RC (SHOW VIEW user_synonyms) = 0
  180. THEN
  181. *
  182.    DROP VIEW user_synonyms
  183. *
  184. IF $RC (SHOW VIEW user_sys_privs) = 0
  185. THEN
  186. *
  187.    DROP VIEW user_sys_privs
  188. *
  189. IF $RC (SHOW VIEW user_tab_audit_opts) = 0
  190. THEN
  191. *
  192.    DROP VIEW user_tab_audit_opts
  193. *
  194. IF $RC (SHOW VIEW user_tab_columns) = 0
  195. THEN
  196. *
  197.    DROP VIEW user_tab_columns
  198. *
  199. IF $RC (SHOW VIEW user_tab_grants) = 0
  200. THEN
  201. *
  202.    DROP VIEW user_tab_grants
  203. *
  204. IF $RC (SHOW VIEW user_tab_grants_made) = 0
  205. THEN
  206. *
  207.    DROP VIEW user_tab_grants_made
  208. *
  209. IF $RC (SHOW VIEW user_tab_grants_recd) = 0
  210. THEN
  211. *
  212.    DROP VIEW user_tab_grants_recd
  213. *
  214. IF $RC (SHOW VIEW user_tab_privs) = 0
  215. THEN
  216. *
  217.    DROP VIEW user_tab_privs
  218. *
  219. IF $RC (SHOW VIEW user_tab_privs_made) = 0
  220. THEN
  221. *
  222.    DROP VIEW user_tab_privs_made
  223. *
  224. IF $RC (SHOW VIEW user_tab_privs_recd) = 0
  225. THEN
  226. *
  227.    DROP VIEW user_tab_privs_recd
  228. *
  229. IF $RC (SHOW VIEW user_tables) = 0
  230. THEN
  231. *
  232.    DROP VIEW user_tables
  233. *
  234. IF $RC (SHOW VIEW user_tablespaces) = 0
  235. THEN
  236. *
  237.    DROP VIEW user_tablespaces
  238. *
  239. IF $RC (SHOW VIEW user_trigger_cols) = 0
  240. THEN
  241. *
  242.    DROP VIEW user_trigger_cols
  243. *
  244. IF $RC (SHOW VIEW user_triggers) = 0
  245. THEN
  246. *
  247.    DROP VIEW user_triggers
  248. *
  249. IF $RC (SHOW VIEW user_ts_quotas) = 0
  250. THEN
  251. *
  252.    DROP VIEW user_ts_quotas
  253. *
  254. IF $RC (SHOW VIEW user_users) = 0
  255. THEN
  256. *
  257.    DROP VIEW user_users
  258. *
  259. IF $RC (SHOW VIEW user_views) = 0
  260. THEN
  261. *
  262.    DROP VIEW user_views
  263. *
  264.  
  265. IF $RC (SHOW VIEW accessible_columns) = 0
  266. THEN
  267. *
  268.    DROP VIEW accessible_columns
  269. *
  270. IF $RC (SHOW VIEW accessible_tables) = 0
  271. THEN
  272. *
  273.    DROP VIEW accessible_tables
  274. *
  275. IF $RC (SHOW VIEW all_catalog) = 0
  276. THEN
  277. *
  278.    DROP VIEW all_catalog
  279. *
  280. IF $RC (SHOW VIEW all_col_comments) = 0
  281. THEN
  282. *
  283.    DROP VIEW all_col_comments
  284. *
  285. IF $RC (SHOW VIEW all_col_grants_made) = 0
  286. THEN
  287. *
  288.    DROP VIEW all_col_grants_made
  289. *
  290. IF $RC (SHOW VIEW all_col_grants_recd) = 0
  291. THEN
  292. *
  293.    DROP VIEW all_col_grants_recd
  294. *
  295. IF $RC (SHOW VIEW all_col_privs) = 0
  296. THEN
  297. *
  298.    DROP VIEW all_col_privs
  299. *
  300. IF $RC (SHOW VIEW all_col_privs_made) = 0
  301. THEN
  302. *
  303.    DROP VIEW all_col_privs_made
  304. *
  305. IF $RC (SHOW VIEW all_col_privs_recd) = 0
  306. THEN
  307. *
  308.    DROP VIEW all_col_privs_recd
  309. *
  310. IF $RC (SHOW VIEW all_cons_columns) = 0
  311. THEN
  312. *
  313.    DROP VIEW all_cons_columns
  314. *
  315. IF $RC (SHOW VIEW all_constraints) = 0
  316. THEN
  317. *
  318.    DROP VIEW all_constraints
  319. *
  320. IF $RC (SHOW VIEW all_db_links) = 0
  321. THEN
  322. *
  323.    DROP VIEW all_db_links
  324. *
  325. IF $RC (SHOW VIEW all_def_audit_opts) = 0
  326. THEN
  327. *
  328.    DROP VIEW all_def_audit_opts
  329. *
  330. IF $RC (SHOW VIEW all_dependencies) = 0
  331. THEN
  332. *
  333.    DROP VIEW all_dependencies
  334. *
  335. IF $RC (SHOW VIEW all_errors) = 0
  336. THEN
  337. *
  338.    DROP VIEW all_errors
  339. *
  340. IF $RC (SHOW VIEW all_ind_columns) = 0
  341. THEN
  342. *
  343.    DROP VIEW all_ind_columns
  344. *
  345. IF $RC (SHOW VIEW all_indexes) = 0
  346. THEN
  347. *
  348.    DROP VIEW all_indexes
  349. *
  350. IF $RC (SHOW VIEW all_objects) = 0
  351. THEN
  352. *
  353.    DROP VIEW all_objects
  354. *
  355. IF $RC (SHOW VIEW all_sequences) = 0
  356. THEN
  357. *
  358.    DROP VIEW all_sequences
  359. *
  360. IF $RC (SHOW VIEW all_snapshots) = 0
  361. THEN
  362. *
  363.    DROP VIEW all_snapshots
  364. *
  365. IF $RC (SHOW VIEW all_source) = 0
  366. THEN
  367. *
  368.    DROP VIEW all_source
  369. *
  370. IF $RC (SHOW VIEW all_synonyms) = 0
  371. THEN
  372. *
  373.    DROP VIEW all_synonyms
  374. *
  375. IF $RC (SHOW VIEW all_tab_columns) = 0
  376. THEN
  377. *
  378.    DROP VIEW all_tab_columns
  379. *
  380. IF $RC (SHOW VIEW all_tab_comments) = 0
  381. THEN
  382. *
  383.    DROP VIEW all_tab_comments
  384. *
  385. IF $RC (SHOW VIEW all_tab_grants_made) = 0
  386. THEN
  387. *
  388.    DROP VIEW all_tab_grants_made
  389. *
  390. IF $RC (SHOW VIEW all_tab_grants_recd) = 0
  391. THEN
  392. *
  393.    DROP VIEW all_tab_grants_recd
  394. *
  395. IF $RC (SHOW VIEW all_tab_privs) = 0
  396. THEN
  397. *
  398.    DROP VIEW all_tab_privs
  399. *
  400. IF $RC (SHOW VIEW all_tab_privs_made) = 0
  401. THEN
  402. *
  403.    DROP VIEW all_tab_privs_made
  404. *
  405. IF $RC (SHOW VIEW all_tab_privs_recd) = 0
  406. THEN
  407. *
  408.    DROP VIEW all_tab_privs_recd
  409. *
  410. IF $RC (SHOW VIEW all_tables) = 0
  411. THEN
  412. *
  413.    DROP VIEW all_tables
  414. *
  415. IF $RC (SHOW VIEW all_trigger_cols) = 0
  416. THEN
  417. *
  418.    DROP VIEW all_trigger_cols
  419. *
  420. IF $RC (SHOW VIEW all_triggers) = 0
  421. THEN
  422. *
  423.    DROP VIEW all_triggers
  424. *
  425. IF $RC (SHOW VIEW all_users) = 0
  426. THEN
  427. *
  428.    DROP VIEW all_users
  429. *
  430. IF $RC (SHOW VIEW all_views) = 0
  431. THEN
  432. *
  433.    DROP VIEW all_views
  434. *
  435.  
  436. IF $RC (SHOW VIEW column_privileges) = 0
  437. THEN
  438. *
  439.    DROP VIEW column_privileges
  440. *
  441. IF $RC (SHOW VIEW constraint_columns) = 0
  442. THEN
  443. *
  444.    DROP VIEW constraint_columns
  445. *
  446. IF $RC (SHOW VIEW constraint_defs) = 0
  447. THEN
  448. *
  449.    DROP VIEW constraint_defs
  450. *
  451. IF $RC (SHOW VIEW dba_2pc_neighbors) = 0
  452. THEN
  453. *
  454.    DROP VIEW dba_2pc_neighbors
  455. *
  456. IF $RC (SHOW VIEW dba_2pc_pending) = 0
  457. THEN
  458. *
  459.    DROP VIEW dba_2pc_pending
  460. *
  461. IF $RC (SHOW VIEW dba_audit_object) = 0
  462. THEN
  463. *
  464.    DROP VIEW dba_audit_object
  465. *
  466. IF $RC (SHOW VIEW dba_audit_session) = 0
  467. THEN
  468. *
  469.    DROP VIEW dba_audit_session
  470. *
  471. IF $RC (SHOW VIEW dba_audit_statemen) = 0
  472. THEN
  473. *
  474.    DROP VIEW dba_audit_statemen
  475. *
  476. IF $RC (SHOW VIEW dba_audit_trail) = 0
  477. THEN
  478. *
  479.    DROP VIEW dba_audit_trail
  480. *
  481. IF $RC (SHOW VIEW dba_blockers) = 0
  482. THEN
  483. *
  484.    DROP VIEW dba_blockers
  485. *
  486. IF $RC (SHOW VIEW dba_catalog) = 0
  487. THEN
  488. *
  489.    DROP VIEW dba_catalog
  490. *
  491. IF $RC (SHOW VIEW dba_clu_columns) = 0
  492. THEN
  493. *
  494.    DROP VIEW dba_clu_columns
  495. *
  496. IF $RC (SHOW VIEW dba_clusters) = 0
  497. THEN
  498. *
  499.    DROP VIEW dba_clusters
  500. *
  501. IF $RC (SHOW VIEW dba_col_comments) = 0
  502. THEN
  503. *
  504.    DROP VIEW dba_col_comments
  505. *
  506. IF $RC (SHOW VIEW dba_col_grants) = 0
  507. THEN
  508. *
  509.    DROP VIEW dba_col_grants
  510. *
  511. IF $RC (SHOW VIEW dba_col_privs) = 0
  512. THEN
  513. *
  514.    DROP VIEW dba_col_privs
  515. *
  516. IF $RC (SHOW VIEW dba_cons_columns) = 0
  517. THEN
  518. *
  519.    DROP VIEW dba_cons_columns
  520. *
  521. IF $RC (SHOW VIEW dba_constraints) = 0
  522. THEN
  523. *
  524.    DROP VIEW dba_constraints
  525. *
  526. IF $RC (SHOW VIEW dba_cross_refs) = 0
  527. THEN
  528. *
  529.    DROP VIEW dba_cross_refs
  530. *
  531. IF $RC (SHOW VIEW dba_data_files) = 0
  532. THEN
  533. *
  534.    DROP VIEW dba_data_files
  535. *
  536. IF $RC (SHOW VIEW dba_db_links) = 0
  537. THEN
  538. *
  539.    DROP VIEW dba_db_links
  540. *
  541. IF $RC (SHOW VIEW dba_ddl_locks) = 0
  542. THEN
  543. *
  544.    DROP VIEW dba_ddl_locks
  545. *
  546. IF $RC (SHOW VIEW dba_dependencies) = 0
  547. THEN
  548. *
  549.    DROP VIEW dba_dependencies
  550. *
  551. IF $RC (SHOW VIEW dba_dml_locks) = 0
  552. THEN
  553. *
  554.    DROP VIEW dba_dml_locks
  555. *
  556. IF $RC (SHOW VIEW dba_errors) = 0
  557. THEN
  558. *
  559.    DROP VIEW dba_errors
  560. *
  561. IF $RC (SHOW VIEW dba_exp_files) = 0
  562. THEN
  563. *
  564.    DROP VIEW dba_exp_files
  565. *
  566. IF $RC (SHOW VIEW dba_exp_objects) = 0
  567. THEN
  568. *
  569.    DROP VIEW dba_exp_objects
  570. *
  571. IF $RC (SHOW VIEW dba_exp_version) = 0
  572. THEN
  573. *
  574.    DROP VIEW dba_exp_version
  575. *
  576. IF $RC (SHOW VIEW dba_extents) = 0
  577. THEN
  578. *
  579.    DROP VIEW dba_extents
  580. *
  581. IF $RC (SHOW VIEW dba_free_space) = 0
  582. THEN
  583. *
  584.    DROP VIEW dba_free_space
  585. *
  586. IF $RC (SHOW VIEW dba_ind_columns) = 0
  587. THEN
  588. *
  589.    DROP VIEW dba_ind_columns
  590. *
  591. IF $RC (SHOW VIEW dba_indexes) = 0
  592. THEN
  593. *
  594.    DROP VIEW dba_indexes
  595. *
  596. IF $RC (SHOW VIEW dba_locks) = 0
  597. THEN
  598. *
  599.    DROP VIEW dba_locks
  600. *
  601. IF $RC (SHOW VIEW dba_obj_audit_opts) = 0
  602. THEN
  603. *
  604.    DROP VIEW dba_obj_audit_opts
  605. *
  606. IF $RC (SHOW VIEW dba_object_size) = 0
  607. THEN
  608. *
  609.    DROP VIEW dba_object_size
  610. *
  611. IF $RC (SHOW VIEW dba_objects) = 0
  612. THEN
  613. *
  614.    DROP VIEW dba_objects
  615. *
  616. IF $RC (SHOW VIEW dba_priv_audit_opt) = 0
  617. THEN
  618. *
  619.    DROP VIEW dba_priv_audit_opt
  620. *
  621. IF $RC (SHOW VIEW dba_profiles) = 0
  622. THEN
  623. *
  624.    DROP VIEW dba_profiles
  625. *
  626. IF $RC (SHOW VIEW dba_role_privs) = 0
  627. THEN
  628. *
  629.    DROP VIEW dba_role_privs
  630. *
  631. IF $RC (SHOW VIEW dba_roles) = 0
  632. THEN
  633. *
  634.    DROP VIEW dba_roles
  635. *
  636. IF $RC (SHOW VIEW dba_rollback_segs) = 0
  637. THEN
  638. *
  639.    DROP VIEW dba_rollback_segs
  640. *
  641. IF $RC (SHOW VIEW dba_segments) = 0
  642. THEN
  643. *
  644.    DROP VIEW dba_segments
  645. *
  646. IF $RC (SHOW VIEW dba_sequences) = 0
  647. THEN
  648. *
  649.    DROP VIEW dba_sequences
  650. *
  651. IF $RC (SHOW VIEW dba_snapshot_logs) = 0
  652. THEN
  653. *
  654.    DROP VIEW dba_snapshot_logs
  655. *
  656. IF $RC (SHOW VIEW dba_snapshots) = 0
  657. THEN
  658. *
  659.    DROP VIEW dba_snapshots
  660. *
  661. IF $RC (SHOW VIEW dba_source) = 0
  662. THEN
  663. *
  664.    DROP VIEW dba_source
  665. *
  666. IF $RC (SHOW VIEW dba_stmt_audit_opt) = 0
  667. THEN
  668. *
  669.    DROP VIEW dba_stmt_audit_opt
  670. *
  671. IF $RC (SHOW VIEW dba_synonyms) = 0
  672. THEN
  673. *
  674.    DROP VIEW dba_synonyms
  675. *
  676. IF $RC (SHOW VIEW dba_sys_audit_opts) = 0
  677. THEN
  678. *
  679.    DROP VIEW dba_sys_audit_opts
  680. *
  681. IF $RC (SHOW VIEW dba_sys_privs) = 0
  682. THEN
  683. *
  684.    DROP VIEW dba_sys_privs
  685. *
  686. IF $RC (SHOW VIEW dba_tab_audit_opts) = 0
  687. THEN
  688. *
  689.    DROP VIEW dba_tab_audit_opts
  690. *
  691. IF $RC (SHOW VIEW dba_tab_columns) = 0
  692. THEN
  693. *
  694.    DROP VIEW dba_tab_columns
  695. *
  696. IF $RC (SHOW VIEW dba_tab_comments) = 0
  697. THEN
  698. *
  699.    DROP VIEW dba_tab_comments
  700. *
  701. IF $RC (SHOW VIEW dba_tab_grants) = 0
  702. THEN
  703. *
  704.    DROP VIEW dba_tab_grants
  705. *
  706. IF $RC (SHOW VIEW dba_tab_privs) = 0
  707. THEN
  708. *
  709.    DROP VIEW dba_tab_privs
  710. *
  711. IF $RC (SHOW VIEW dba_tables) = 0
  712. THEN
  713. *
  714.    DROP VIEW dba_tables
  715. *
  716. IF $RC (SHOW VIEW dba_tablespaces) = 0
  717. THEN
  718. *
  719.    DROP VIEW dba_tablespaces
  720. *
  721. IF $RC (SHOW VIEW dba_trigger_cols) = 0
  722. THEN
  723. *
  724.    DROP VIEW dba_trigger_cols
  725. *
  726. IF $RC (SHOW VIEW dba_triggers) = 0
  727. THEN
  728. *
  729.    DROP VIEW dba_triggers
  730. *
  731. IF $RC (SHOW VIEW dba_ts_quotas) = 0
  732. THEN
  733. *
  734.    DROP VIEW dba_ts_quotas
  735. *
  736. IF $RC (SHOW VIEW dba_users) = 0
  737. THEN
  738. *
  739.    DROP VIEW dba_users
  740. *
  741. IF $RC (SHOW VIEW dba_views) = 0
  742. THEN
  743. *
  744.    DROP VIEW dba_views
  745. *
  746. IF $RC (SHOW VIEW dba_waiters) = 0
  747. THEN
  748. *
  749.    DROP VIEW dba_waiters
  750. *
  751. IF $RC (SHOW VIEW dict_columns) = 0
  752. THEN
  753. *
  754.    DROP VIEW dict_columns
  755. *
  756. IF $RC (SHOW VIEW dictionary) = 0
  757. THEN
  758. *
  759.    DROP VIEW dictionary
  760. *
  761. IF $RC (SHOW VIEW exceptions) = 0
  762. THEN
  763. *
  764.    DROP VIEW exceptions
  765. *
  766. IF $RC (SHOW VIEW global_name) = 0
  767. THEN
  768. *
  769.    DROP VIEW global_name
  770. *
  771. IF $RC (SHOW VIEW public_dependency) = 0
  772. THEN
  773. *
  774.    DROP VIEW public_dependency
  775. *
  776. IF $RC (SHOW VIEW resource_cost) = 0
  777. THEN
  778. *
  779.    DROP VIEW resource_cost
  780. *
  781. IF $RC (SHOW VIEW role_role_privs) = 0
  782. THEN
  783. *
  784.    DROP VIEW role_role_privs
  785. *
  786. IF $RC (SHOW VIEW role_sys_privs) = 0
  787. THEN
  788. *
  789.    DROP VIEW role_sys_privs
  790. *
  791. IF $RC (SHOW VIEW role_tab_privs) = 0
  792. THEN
  793. *
  794.    DROP VIEW role_tab_privs
  795. *
  796. IF $RC (SHOW VIEW session_privs) = 0
  797. THEN
  798. *
  799.    DROP VIEW session_privs
  800. *
  801. IF $RC (SHOW VIEW session_roles) = 0
  802. THEN
  803. *
  804.    DROP VIEW session_roles
  805. *
  806. IF $RC (SHOW VIEW table_privileges) = 0
  807. THEN
  808. *
  809.    DROP VIEW table_privileges
  810. *
  811.  
  812. IF $RC (SHOW TABLE audit_actions) = 0
  813. THEN
  814. *
  815.    DROP TABLE audit_actions
  816. *
  817. IF $RC (SHOW TABLE stmt_audit_option_map) = 0
  818. THEN
  819. *
  820.    DROP TABLE stmt_audit_option_map
  821. *
  822. IF $RC (SHOW TABLE table_privilege_map) = 0
  823. THEN
  824. *
  825.    DROP TABLE table_privilege_map
  826. *
  827. SQLMODE ADABAS
  828. *
  829. USE USER &u
  830. *
  831.