WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Latest posts

latest posts

MVP
In reply to: Maksymilian Stachowiak

I'm not sure how it works in SaaS model, although on prem db admin could create a schema called 'custom', and give permissions only to that schema. This way it should be safe enough to not destroy WEBCON objects :)

Hi,

even so this is solved I wanted to add two comments:

SaaS
You don't have privileges to modify the database. The action for executing SQL or PowerShell are not available.


Adding functions views to the database
This is something you do at your own discretion and sometimes it's necessary. For example if you need to use the row_number function you have to use a few.
If you are using this option, you may consider this approach:
https://daniels-notes.de/posts/2021/deploying-database-scripts
I haven't updated the mentioned application in a long time.


Best regards,
Daniel

MVP
In reply to: Jack

yes - function may be a better solution but sometimes it is not possible to modify/add anything to the database :/

I'm not sure how it works in SaaS model, although on prem db admin could create a schema called 'custom', and give permissions only to that schema. This way it should be safe enough to not destroy WEBCON objects :)