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 |
|
psangeetha
Yak Posting Veteran
95 Posts |
 Posted - 2010-09-03 : 11:37:17
|
| Hi friends,I created a new user and gave control permission the user in the database. But when I log in the management studio as this user, I'm not able to see all the tables or stored procedures in the database. But I'm able to run select,update delete etc on all the tables.. just not able to see them in the management studio.. Please help me..Thank you |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-03 : 11:44:44
|
| GRANT VIEW DEFINITION to <user> |
 |
|
|
psangeetha
Yak Posting Veteran
95 Posts |
Posted - 2010-09-03 : 11:57:46
|
| Thanks. I just gave grant view definition to approle and the user executed this approle. But still don't see all the tables in the management studio... Also, I gave grant control permission to the approle, but the user is not able to create any new procedures or execute the existing procedures..please help..thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-03 : 14:25:16
|
| make it db_datareader and grant view definition is all u need |
|
|
|
|
|
|
grant permission