1 files changed, 8 insertions, 8 deletions

diff --git a/sql/mlpdb.sql b/sql/serenitasdb.sql
index 601b9dfa..fbc6641c 100644
--- a/sql/mlpdb.sql
+++ b/sql/serenitasdb.sql
@@ -23,7 +23,7 @@ CREATE TABLE tranche_data (
        CumulativeLoss float

 );

 

-GRANT ALL ON tranche_data TO mlpdb_user;

+GRANT ALL ON tranche_data TO serenitas_user;

 

 CREATE TABLE index_version(

        BasketID serial,

@@ -48,9 +48,9 @@ CREATE OR REPLACE VIEW index_desc AS
    FROM index_maturity a

    JOIN index_version b ON a.index = b.index AND a.series = b.series;

 

-GRANT ALL ON index_maturity TO mlpdb_user;

-GRANT ALL ON index_version TO mlpdb_user;

-GRANT ALL ON index_desc TO mlpdb_user;

+GRANT ALL ON index_maturity TO serenitas_user;

+GRANT ALL ON index_version TO serenitas_user;

+GRANT ALL ON index_desc TO serenitas_user;

 

 

 CREATE TABLE quotes (

@@ -97,8 +97,8 @@ CREATE TABLE tranche_quotes (
        PRIMARY KEY(QuoteDate, Index, Series, Version, Tenor, Attach, Detach, QuoteSource)

 );

 

-GRANT ALL ON quotes TO mlpdb_user;

-GRANT ALL ON tranche_quotes TO mlpdb_user;

+GRANT ALL ON quotes TO serenitas_user;

+GRANT ALL ON tranche_quotes TO serenitas_user;

 

 -- Idiosyncracies:

 

@@ -147,7 +147,7 @@ CREATE TABLE CDS_Issuers(
        markit_tier tier,

        PRIMARY KEY(company_id));

 

-GRANT ALL ON  CDS_Issuers to mlpdb_user;

+GRANT ALL ON  CDS_Issuers to serenitas_user;

 

 CREATE TABLE cds_quotes(

        Date Date,

@@ -160,7 +160,7 @@ CREATE TABLE cds_quotes(
        Recovery float,

        PRIMARY KEY(curve_ticker, Date));

 

-GRANT ALL ON cds_quotes to mlpdb_user;

+GRANT ALL ON cds_quotes to serenitas_user;

 

 CREATE OR REPLACE FUNCTION nameToBasketID(index_name varchar(4), p_date date) RETURNS integer AS $$

        DECLARE