Permission sp_rename

[Clas Andersson]

I am creating a dynamic pivot-table with web - sql-server 2008 When the pivot-table is created i want to rename columnname. I am execute a stored procedure, sp_rename..... from the web-page. Web-page - select variablesnames Web-page - variablesname --> short columnname SQl-server - create pivot table (dynamic sql, short columnnames - 4000 char limit) Web-page/Sql-server - rename short columnnames to variablesnames The problem is the permission to execute sp_rename . How/where can I adjust permission for the the "webuser" in sql-server ? Thanks in advance Clas

[Mycroft Holmes]

I am assuming that you need this table only for display on your form, in which case why don't you rename the columns in the UI!

Never underestimate the power of human stupidity RAH