Yes, that work out.

But in my production enviornment i am not not allowed to provide the grant to the schema.

Do anyone has some other solution.