Wednesday, December 2, 2015

Limiting User Privileges when you install sample reports

[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';


[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

Share this

0 Comment to "Limiting User Privileges when you install sample reports"

Post a Comment