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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2004-05-13 : 01:00:48
|
We have some 3rd party software running in house and in most of their stored procs they have a grant statement to specific db users at the end of each proc. Example:create proc sp_dostuffasselect stuff from tblstuff where stuff like 'Stuff%'grant execute to user1, user2 on sp_dostuff I have always been told this is very bad practice. I would assume because the db is having to grant permissions very single time you run the sproc. Anyone have comments on this?Thanks. DanielSQL Server DBA |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-05-13 : 01:14:31
|
| That is f#$^%ing awful.DavidM"Always pre-heat the oven" |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-13 : 01:48:16
|
| Looks like someone forgot some GO directives...Damian |
|
|
|
|
|
|
Grant permissions in a stored proc?