*   *ID* ORADDSYN CMD      changed on 1994-02-08-12.10.57 by KRISCHAN  *

* This file should contain a list of synonyms that are known to public.
* Because in ADABAS synonyms are just private renamings, these are defined
* as views, which can be granted to public
*

INIT SERVERDB
*
SQLMODE ADABAS
*
USE USER sys sys
*
SQLMODE ORACLE
*

CREATE VIEW cat                AS SELECT * FROM sys.user_catalog
*
GRANT ALL ON cat TO PUBLIC
*
CREATE VIEW clu                AS SELECT * FROM sys.user_clusters
*
GRANT ALL ON clu TO PUBLIC
*
CREATE VIEW cols               AS SELECT * FROM sys.user_tab_columns
*
GRANT ALL ON cols TO PUBLIC
*
CREATE VIEW dict               AS SELECT * FROM sys.dictionary
*
GRANT ALL ON dict TO PUBLIC
*
CREATE VIEW ind                AS SELECT * FROM sys.user_indexes
*
GRANT ALL ON ind TO PUBLIC
*
CREATE VIEW obj                AS SELECT * FROM sys.user_objects
*
GRANT ALL ON obj TO PUBLIC
*
CREATE VIEW seq                AS SELECT * FROM sys.user_sequences
*
GRANT ALL ON seq TO PUBLIC
*
CREATE VIEW syn                AS SELECT * FROM sys.user_synonyms
*
GRANT ALL ON syn TO PUBLIC
*
CREATE VIEW tabs               AS SELECT * FROM sys.user_tables
*
GRANT ALL ON tabs TO PUBLIC
*
SQLMODE ADABAS
*
USE USER &u
*

* ------------------------------------------------------------------------
* In the dd-view all_synonyms should be a list of all the dd-views itselfs
* from sys to public. Only for this purpose we created the user public, who
* will now get a bunch of synonyms
*

SQLMODE ADABAS
*
USE USER "PUBLIC" illegal
*
SQLMODE ORACLE
*

CREATE SYNONYM all_catalog           FOR sys.all_catalog
*
CREATE SYNONYM all_col_comments      FOR sys.all_col_comments
*
CREATE SYNONYM all_col_privs         FOR sys.all_col_privs
*
CREATE SYNONYM all_col_privs_made    FOR sys.all_col_privs_made
*
CREATE SYNONYM all_col_privs_recd    FOR sys.all_col_privs_recd
*
CREATE SYNONYM all_constraints       FOR sys.all_constraints
*
CREATE SYNONYM all_cons_columns      FOR sys.all_cons_columns
*
CREATE SYNONYM all_db_links          FOR sys.all_db_links
*
CREATE SYNONYM all_def_audit_opts    FOR sys.all_def_audit_opts
*
CREATE SYNONYM all_dependencies      FOR sys.all_dependencies
*
CREATE SYNONYM all_errors            FOR sys.all_errors
*
CREATE SYNONYM all_indexes           FOR sys.all_indexes
*
CREATE SYNONYM all_ind_columns       FOR sys.all_ind_columns
*
CREATE SYNONYM all_objects           FOR sys.all_objects
*
CREATE SYNONYM all_sequences         FOR sys.all_sequences
*
CREATE SYNONYM all_snapshots         FOR sys.all_snapshots
*
CREATE SYNONYM all_source            FOR sys.all_source
*
CREATE SYNONYM all_synonyms          FOR sys.all_synonyms
*
CREATE SYNONYM all_tables            FOR sys.all_tables
*
CREATE SYNONYM all_tab_columns       FOR sys.all_tab_columns
*
CREATE SYNONYM all_tab_comments      FOR sys.all_tab_comments
*
CREATE SYNONYM all_tab_privs         FOR sys.all_tab_privs
*
CREATE SYNONYM all_tab_privs_made    FOR sys.all_tab_privs_made
*
CREATE SYNONYM all_tab_privs_recd    FOR sys.all_tab_privs_recd
*
CREATE SYNONYM all_triggers          FOR sys.all_triggers
*
CREATE SYNONYM all_trigger_cols      FOR sys.all_trigger_cols
*
CREATE SYNONYM all_users             FOR sys.all_users
*
CREATE SYNONYM all_views             FOR sys.all_views
*
CREATE SYNONYM column_privileges     FOR sys.column_privileges
*
CREATE SYNONYM dictionary            FOR sys.dictionary
*
CREATE SYNONYM dict_columns          FOR sys.dict_columns
*
CREATE SYNONYM exceptions            FOR sys.exceptions
*
CREATE SYNONYM global_name           FOR sys.global_name
*
CREATE SYNONYM public_dependency     FOR sys.public_dependency
*
CREATE SYNONYM resource_cost         FOR sys.resource_cost
*
CREATE SYNONYM role_role_privs       FOR sys.role_role_privs
*
CREATE SYNONYM role_sys_privs        FOR sys.role_sys_privs
*
CREATE SYNONYM role_tab_privs        FOR sys.role_tab_privs
*
CREATE SYNONYM session_privs         FOR sys.session_privs
*
CREATE SYNONYM session_roles         FOR sys.session_roles
*
CREATE SYNONYM table_privileges      FOR sys.table_privileges
*
CREATE SYNONYM user_audit_object     FOR sys.user_audit_object
*
CREATE SYNONYM user_audit_session    FOR sys.user_audit_session
*
CREATE SYNONYM user_audit_statement  FOR sys.user_audit_statement
*
CREATE SYNONYM user_audit_trail      FOR sys.user_audit_trail
*
CREATE SYNONYM user_catalog          FOR sys.user_catalog
*
CREATE SYNONYM user_clusters         FOR sys.user_clusters
*
CREATE SYNONYM user_clu_columns      FOR sys.user_clu_columns
*
CREATE SYNONYM user_col_comments     FOR sys.user_col_comments
*
CREATE SYNONYM user_col_privs        FOR sys.user_col_privs
*
CREATE SYNONYM user_col_privs_made   FOR sys.user_col_privs_made
*
CREATE SYNONYM user_col_privs_recd   FOR sys.user_col_privs_recd
*
CREATE SYNONYM user_constraints      FOR sys.user_constraints
*
CREATE SYNONYM user_cons_columns     FOR sys.user_cons_columns
*
CREATE SYNONYM user_db_links         FOR sys.user_db_links
*
CREATE SYNONYM user_dependencies     FOR sys.user_dependencies
*
CREATE SYNONYM user_errors           FOR sys.user_errors
*
CREATE SYNONYM user_extents          FOR sys.user_extents
*
CREATE SYNONYM user_free_space       FOR sys.user_free_space
*
CREATE SYNONYM user_indexes          FOR sys.user_indexes
*
CREATE SYNONYM user_ind_columns      FOR sys.user_ind_columns
*
CREATE SYNONYM user_objects          FOR sys.user_objects
*
CREATE SYNONYM user_object_size      FOR sys.user_object_size
*
CREATE SYNONYM user_obj_audit_opts   FOR sys.user_obj_audit_opts
*
CREATE SYNONYM user_resource_limits  FOR sys.user_resource_limits
*
CREATE SYNONYM user_role_privs       FOR sys.user_role_privs
*
CREATE SYNONYM user_segments         FOR sys.user_segments
*
CREATE SYNONYM user_sequences        FOR sys.user_sequences
*
CREATE SYNONYM user_snapshots        FOR sys.user_snapshots
*
CREATE SYNONYM user_snapshot_logs    FOR sys.user_snapshot_logs
*
CREATE SYNONYM user_source           FOR sys.user_source
*
CREATE SYNONYM user_synonyms         FOR sys.user_synonyms
*
CREATE SYNONYM user_sys_privs        FOR sys.user_sys_privs
*
CREATE SYNONYM user_tables           FOR sys.user_tables
*
CREATE SYNONYM user_tablespaces      FOR sys.user_tablespaces
*
CREATE SYNONYM user_tab_columns      FOR sys.user_tab_columns
*
CREATE SYNONYM user_tab_comments     FOR sys.user_tab_comments
*
CREATE SYNONYM user_tab_privs        FOR sys.user_tab_privs
*
CREATE SYNONYM user_tab_privs_made   FOR sys.user_tab_privs_made
*
CREATE SYNONYM user_tab_privs_recd   FOR sys.user_tab_privs_recd
*
CREATE SYNONYM user_triggers         FOR sys.user_triggers
*
CREATE SYNONYM user_trigger_cols     FOR sys.user_trigger_cols
*
CREATE SYNONYM user_ts_quotas        FOR sys.user_ts_quotas
*
CREATE SYNONYM user_users            FOR sys.user_users
*
CREATE SYNONYM user_views            FOR sys.user_views
*
CREATE SYNONYM audit_actions         FOR sys.audit_actions
*
CREATE SYNONYM stmt_audit_option_map FOR sys.stmt_audit_option_map
*
CREATE SYNONYM table_privilege_map   FOR sys.table_privilege_map
*

SQLMODE ADABAS
*
USE USER &u
*
END INIT SERVERDB
*
