Had a question on best approach with some security issues around on the fly table creation by a user.
I want to users to create dynamic tables from the application. This means that the user logged in should have create table privileges at the database level. Assuming this is a security risk for allowing all users to have table creation privileges. is it possible to create some sort of trigger to allow the user to create table when ready and once it's done revoke it automatically?
What is the best approach conceptual wise and security wise when dealing with these situations? The less the user can do on the database the better it is?