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 |
boing
Starting Member
8 Posts |
Posted - 2006-09-05 : 07:25:15
|
Hi,Here's my problem - I want our normal SQL users, called 'WebUser' to be able to view a view called 'sjView'...However, the table(s) this view is made up of is not accessible by WebUser, hence causing a permissions error when trying to look at it. I tried to give the view SELECT permissions etc to WebUser, but this didn't work - It just allowed me to view the view code etc.Overall, what I want is WebUser to be able to view the sjView table, but not the tables it derives from.How is this possible?Thanks,Cormac Redmond |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-05 : 07:42:06
|
GRANT SELECT ON sjView TO WebUser did not work?Peter LarssonHelsingborg, Sweden |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-05 : 07:44:26
|
Harsh AthalyeIndia."Nothing is Impossible" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-05 : 07:48:44
|
This works for meDENY SELECT ON [Table_Name] TO [Webuser] CASCADE GRANT SELECT ON [sjView] TO [Test] When logging in as WebUser, SELECT * FROM Table_Name throws an error, but SELECT * FROM sjView workd great!Peter LarssonHelsingborg, Sweden |
|
|
boing
Starting Member
8 Posts |
Posted - 2006-09-05 : 11:48:14
|
Thanks, that worked nicely!I never did GRANT SELECT ON [sjView] TO [Webuser], but I did give sjView SELECT permissions to Webuser from Enterprise Manager, which I presumed would do the same thing. What's the difference? |
|
|
|
|
|
|
|