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 |
|
algademius
Starting Member
1 Post |
 Posted - 2011-03-31 : 08:19:25
|
| Hello! Help please! Such a problem: There is a group of developers who will create a stored procedure. Have a user "script", from under which the application executes these stored procedures. How to implement access so that programmers could work only with their specific procedures and have only seen some of the tables and then (important) to give the right to "execute" to a stored procedure for user "script"? |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-31 : 10:47:43
|
| You can grant EXECUTE permission on stored procedures to specific users, but I am not sure how to limit their visibility of all the objects (tables, stored procs, views) in a database without restricting database access all together.Hey, it compiles. |
 |
|
|
|
|
|
Access rights