I have created a stored procedure in SQL 6.5 which does a CREATE TABLE with column names that are generated from within the procedure. In order for the temporary table to be created, I had to put the create table statements into a string, and then use an exec( to run it. However, although the stored proc works fine for me as an sa, it won&#039t work for my IIS account, and I get an &#039invalid object name&#039 message when it runs the proc.<BR><BR>I&#039m stumped, as it appears that I can&#039t grant permission to create the table in the proc (only the dbo can do this), and I can&#039t grant permission outside of the proc as it&#039s a temporary table (preceded with a # symbol). What can I do???<BR><BR>Thanks in anticipation.<BR>