[oracle@PTUD-S07 ~]$ more a.sql
SET LINESIZE 32000;
SET PAGESIZE 40000;
SET LONG 50000;
select 'CREATE OR REPLACE EDITIONABLE SYNONYM OCDM_REPORT.'||Table_Name||' for OCDM_SYS.'||Table_Name||';' from All_Tables where owner='OCDM_SYS';
SET LINESIZE 32000;
SET PAGESIZE 40000;
SET LONG 50000;
select 'CREATE OR REPLACE EDITIONABLE SYNONYM OCDM_REPORT.'||Table_Name||' for OCDM_SYS.'||Table_Name||';' from All_Tables where owner='OCDM_SYS';
[oracle@PTUD-S07 ~]$ sqlplus / as sysdba @a.sql >> b.sql &
[4] 141981
[oracle@PTUD-S07 ~]$ cat b.sql | grep 'CREATE OR REPLACE EDITIONABLE SYNONYM' >> c.sql
[4]+ Stopped sqlplus / as sysdba @a.sql >> b.sql
[oracle@PTUD-S07 ~]$ sqlplus / as sysdba @c.sql
0 Comment to "Limiting User Privileges when you install sample reports"
Post a Comment