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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-05-08 : 18:04:21
|
| I have set up a couple of views for a user but they want to be able to see the database table columns by doing right click on table and getting the columsn.I tried to give the permissions to database by right clicking on database and doing the user and giving view defintion.-- [TABLEA] contains no columns that can be inserted or the current user does not have permissions on that object.User not allowed to select the data .Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-08 : 22:42:51
|
| Tried add securable to user instead? |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-05-09 : 07:45:45
|
| Add table to the user too - its all tables in db i could be there a while... |
|
|
|
|
|
|
Allow user to see table definition