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 |
|
kirannatt
Yak Posting Veteran
66 Posts |
 Posted - 2006-09-22 : 17:39:20
|
| Hi All,I need to set up permission on master db stored proc "xp_regex_replace". it is extended stored proc in my case.Does any one has an idea how to set up permissions on stored proc.Thanks! |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-09-22 : 17:48:33
|
| [code]grant exec on xp_regex_replace to public[/code] |
 |
|
|
kirannatt
Yak Posting Veteran
66 Posts |
Posted - 2006-09-22 : 18:13:55
|
| Thanks for the quick response! |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-09-22 : 18:18:08
|
| Glad to help, but please make reference to books online for the full TSQL reference on it.Afrika |
|
|
|
kirannatt
Yak Posting Veteran
66 Posts |
Posted - 2006-09-22 : 18:19:13
|
| I had deadline today so didn't have enough time but I liked your suggestion. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-09-22 : 18:51:13
|
quote:
I had deadline today so didn't have enough time but I liked your suggestion.
Are you kidding me? Is your Start menu broken? Books Online is already on your computer. There's an index tab, type in the word "permissions" in the box and it takes you straight to the section on granting permissions.It took you FAR longer to post this question in the forum than it would have taken you to look it up in BOL. |
|
|
|
|
|
|
How to setup permissions on stored procedure