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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Viewing a view problem (permissions)

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 Larsson
Helsingborg, Sweden
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-09-05 : 07:44:26


Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-05 : 07:48:44
This works for me
DENY 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 Larsson
Helsingborg, Sweden
Go to Top of Page

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?
Go to Top of Page
   

- Advertisement -