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 |
|
koln5
Starting Member
29 Posts |
 Posted - 2012-10-29 : 20:07:19
|
| I need to give user Joe select permissions to a view. The view has columns from two tables from the same database (ABC). Joe should only see the columns in this view, not any underlying tables. I should mention that the two tables are owned by Dave.I thought by writing: "GRANT SELECT ON View1 TO Joe;"but its not working...I receive the following error;The SELECT permission was denied on the object 'tblReviews', database 'ABC', schema 'Dave'.What else can I do ? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-10-29 : 22:11:48
|
| You need to grant Joe SELECT permission in Dave's schema-Chad |
 |
|
|
|
|
|
Give permission to a user to ONLY a view