Create Table Permission

[SusanK]

I have to create a table before running a report. The table cannot be
generated through queries because it requires a series of queries that end up
with multi level group by's not allowed and the last query needs to be a
cross tab.

Without the admin privileges the user gets an error that they cannot modify
the design of a table. I have tried giving the user all priveleges for new
tables but this hasn't helped. Any suggestions?

 

[Joan Wild]

Instead of deleting/creating a table each time, you could create your table, and then use a delete and append queries to empty/populate the table. You could make these queries RWOP and the user wouldn't need any permissions on the table.