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 |
|
tommypa
Starting Member
19 Posts |
 Posted - 2009-01-20 : 15:50:07
|
| Good afternoon,With read-only privileges are you able to run STPs? If not this there another level of permission? Tommy |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-20 : 16:03:08
|
| What is STPs? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tommypa
Starting Member
19 Posts |
Posted - 2009-01-21 : 09:19:40
|
| Where do you assign the execute role? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 10:22:49
|
Through permission.Grant Execute on [schema].[store proc] to [user] Or Right click Store procedure and give permission from properties. |
|
|
|
tommypa
Starting Member
19 Posts |
Posted - 2009-01-21 : 10:32:43
|
| Thank you so much. Where do stored procedures normally live? I am browsing around and can't seem to find them. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 10:41:35
|
| What does Booksonline say? It comes with SQL Server. |
|
|
|
|
|
|
Read Only Permission