diff options
| -rw-r--r-- | sql/et_tables.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index dc8a47a3..c5ef2354 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -442,7 +442,8 @@ CREATE OR REPLACE FUNCTION historical_dealname_universe(p_dealname varchar(10), $$ LANGUAGE plpgsql; CREATE OR REPLACE VIEW dealcusipmapping AS - SELECT dealname, cusip from cusip_ref; + select cusip, dealname from deal_indicative join cusip_ref using (dealname) where paid_down is null; + GRANT ALL ON dealcusipmapping TO et_user; |