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 |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2006-12-11 : 19:33:57
|
| does anyone know how to do this, its :GRANT EXECUTE ...for 2005 but for 2000? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-11 : 19:51:01
|
| Same thing for 2000. Here's an example:GRANT EXEC ON SomeProc TO SomeUserCheck out SQL Server Books Online for details.Tara Kizer |
 |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-11 : 23:13:23
|
| thanx |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-11 : 23:29:54
|
| sorry i just found i asked the questions incorrectly what i want is to create execute permission on all sp's... for examplei use this in 2005:exec sp_msforeachdb 'if ''?'' <> ''master'' and ''?'' <> ''model'' and ''?'' <> ''msdb'' and ''?'' <> ''tempdb'' begin USE ? GRANT EXECUTE TO sp_executor end'and it works fine but not 2000 |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-12 : 00:14:14
|
You haven't specified the SP on which you want to grant permission.GRANT EXECUTE ON proc1 TO sp_executor Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-12 : 00:37:38
|
| yeah thanx but im after making proc1 automatically entered rather then me type in all procedure names |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
grant execute permission in 2000