As we all know that creating a new table as part of code deployment,would require admin permission on DB user .
How can we provide the same without having outage window?
Also, we noticed that even we promote/demote the permission on DB user runtime, it still keep the same permission with existing connection from pool and doesn't change the permission for existing connections.
Any help would be appreciated here.
***Edited by Moderator: Pooja Gadige to change content format from Discussion to Question***