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 |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2014-04-08 : 04:45:33
|
| Hello all,I need to create an account on SQL Server 2012 that is not dbowner but can see all the tables and also all the stored procedure without any possibilty to modify data in tables, and modify stored (the user can see the code of the stored, but can not execute or modify them). Is it possible to have this? Thanks a lot. Luis |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-04-30 : 19:15:16
|
| GRANT VIEW DEFINITION TO [MyUser];===============================================================================“Everyone wants a better life: very few of us want to be better people.” -Alain de Botton |
 |
|
|
|
|
|
Account DataReader also on stored procedures