Test Data Manager

Expand all | Collapse all

CREATE VIEW permission denied in database 'GTREP'

Jump to Best Answer
  • 1.  CREATE VIEW permission denied in database 'GTREP'

    Posted 05-10-2020 02:35 PM
      |   view attached
    Hi,

    I am using CA-TDM portal for generating synthetic data.
    When I try to publish the data, I am facing "CREATE VIEW permission denied in database 'GTREP'' error.
    I am a novice in CA-TDM tool. Could you please explain why this is happening and what actually I need to get this done?

    ------------------------------
    Vishnu Raj
    Legato Health Technologies
    ------------------------------

    Attachment(s)

    zip
    9.zip   1K 1 version


  • 2.  RE: CREATE VIEW permission denied in database 'GTREP'
    Best Answer

    Posted 05-11-2020 02:53 AM
    Hi Vishnu,

    I think its about your collation settings. I faced this kind of issue before, but it was in datamaker. I changed my sql server instance collation and db collation to "SQL_Latin1_General_CP1_CI_AS" then it worked. Maybe you need to reinstall repository db after this setting.

    Hope it helps you as well.

    Best regards,
    Cem


  • 3.  RE: CREATE VIEW permission denied in database 'GTREP'

    Posted 05-11-2020 03:01 AM
    Hi Cem,

    Can you just explain me how to change server instance collation and DB collation and also how to reinstall repository.
    I am very new to this tool. Also can you please tell me whether we need Admin level access in CA-TDM tool to perform these actions.


  • 4.  RE: CREATE VIEW permission denied in database 'GTREP'

    Posted 05-11-2020 02:58 AM
    Hi,

    The database user should have at least create View permission

    Regards, Dahman





  • 5.  RE: CREATE VIEW permission denied in database 'GTREP'

    Posted 05-11-2020 03:06 AM
    Hi Dahman,

    Just for clarification. You mean that I need to have create view permission in the database I mentioned in the connection profile I created?
    If not please correct me.