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 |
|
dee-u
Starting Member
14 Posts |
 Posted - 2009-06-13 : 12:35:52
|
| How do I do it such that I one would be able to access the tables via Stored Procedures?TIA |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-13 : 22:16:11
|
| just grant exec on stored procedures to the user..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
dee-u
Starting Member
14 Posts |
Posted - 2009-06-16 : 12:14:45
|
| Thanks for the idea although I think I need further help since I am new to this.I will have to add a new login in the Security Menu -> Logins but what database role should I use? Only PUBLIC?And is there a way to just grant the use all the rights to all existing SP without ticking those options?TIA |
|
|
|
|
|
|
Allow access to tables using SPs