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?
Thanks!