Usually for things like that you would have the user submit
a script for a DBA or someone with sysadmin access to
execute. But...
Probably one of the easiest ways to handle doing it the way
you requested is to add the user to one of the roles that
allows them to perform whatever function and then remove the
user from that role when they are done.
The user wouldn't need sa permissions to alter a column. You
could add that user to the db_ddladmin role in the database
where they want to make the change.

-Sue

On Fri, 29 Sep 2006 19:41:32 +0200, "Sam"
[quoted text, click to view]