CREATE VIEW permission denied in database 'GTREP'

[Vishnu Raj]

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)

9.zip   1 KB 1 version

[Cem Kara]

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

[Vishnu Raj]

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.

[Abderrahmane Zahrir]

Hi,

The database user should have at least create View permission

Regards, Dahman

[Vishnu Raj]

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.