SHOW:
|
|
- or go back to the newest paste.
| 1 | - | jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER = ON)(LOAD_BALANCE = OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cluprod-scan.entreprise.tpf.ch)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=clustb-scan.entreprise.tpf.ch)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME = CARL))) |
| 1 | + | jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER = ON)(LOAD_BALANCE = OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cluprod-scan.entreprise.tpf.ch)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=clustb-scan.entreprise.tpf.ch)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME = CARL))) |
| 2 | ||
| 3 | FOR x IN (SELECT * FROM user_tables) | |
| 4 | ||
| 5 | LOOP | |
| 6 | ||
| 7 | EXECUTE IMMEDIATE 'GRANT SELECT ON ' || x.table_name || ' TO <<someone>>'; | |
| 8 | ||
| 9 | END LOOP; |
