Sql 2000 permissions,HELP ME!!!
Hi guy,this is my problem:
user Sam has permission only like db_writer,db_reader and another, test, customizable. He isn't a ddladmin or db owner. Now, in the db, there are object only with dbo as owner, and this is the way that have to remain. But in the application there are a lot of statements (like truncate or alter table) that need higher permissions to be executed, higher Sam's permissions. I read that in sql 2005 it is possible with EXECUTE AS command on a s.procedure, but it seems that in sql 2000 there is any way to do a similiar operation. So, my question is:
is there a procedure that grant permission to Sam to manipulate dbo.object (truncate or alter table)?
Please answer me in simple english...i'm italian guy.