Stored Procedure help

[Clundey]

I am trying to create two tables via a stored procedure, RECEIVED and DISTRIBUTED. Then use those tables as part of a crystal report that compares those tables with an existing table. The stored procedure will be crystal data source.

Problem is the stored procedure needs to delete existing RECV & DIST, create new ones, assign select permissions.
I need all users 2b able to run this. I have a sp that will make the tables, but am tripping on permissions etc. I only want to give create/delete on these tables.

Thanks in advance for any help!

 

[SQLSister]

Bad design! You do NOT want users to delete and create tables! Use temp tables in your stored procedure instead. That way if two users try to do something simliar at the same time they won't be wiping out the data someone else put in before they had a chance to process it!