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 |
|
waveform
Yak Posting Veteran
93 Posts |
 Posted - 2011-12-04 : 07:06:22
|
| In SQL2008, the application uses a login which has db_datareader and db_datawriter access. But the application now also needs to read table schemas. Not modify them, just read them - get the column names and types.What is the minimum permissions needed for that user to get table schemas? |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-12-04 : 09:29:32
|
| GRANT VIEW DEFINITION to {login}; |
 |
|
|
waveform
Yak Posting Veteran
93 Posts |
Posted - 2011-12-04 : 10:05:01
|
| Many thanks! New to SQL2008. :) |
|
|
|
|
|
|
Minimum permissions needed to get table schema