One of our programmer creates an Stored Procedure that will drop a table and create new one. We are controlling SQL Users and we wanted to restrict application access to the database. I have previously created a user that is a db_datareader which is not applicable on this scenario.
What Database Role do I need to set?
Btw, I am using MS SQL 2000