Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kpmkrishnan
Starting Member
11 Posts |
 Posted - 2007-01-19 : 13:44:54
|
| hi, i have a sp DeployData which has some truncate table statementsthere are two users A & B. A has db_ddladmin rights and can execute the above sp without issues. while B has only db_datareader and db_datawriter perm. User B has been given grant to execute the above sp and while executing causes error in the truncate table line.Is there a way i can allow B to execute the Sp without giving him additional rights.Your Help is highly appreciated.ThanksKishore |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-19 : 14:49:42
|
| With SQL Server 2005 you can.Peter LarssonHelsingborg, Sweden |
 |
|
|
kpmkrishnan
Starting Member
11 Posts |
Posted - 2007-01-19 : 14:57:28
|
| Thank you very much. Is there a workaround in 2000. I can use delete statement instead of truncate but then my performance is going to degrade as i use them a lot in the sp in a loop to perform some complicated calculation .Other than delete, is there a work around ?Thanks K |
|
|
|
|
|
|
URGENT: Execute SP as different USER