I don't see why my user cannot see a view when she can see the tables that
underlie it and has also been granted select permission on the view.

exec sp_grantlogin [OURDOMAIN\user99]
exec sp_grantdbaccess [OURDOMAIN\user99], 'SARAH'

exec sp_addrole 'TheRole'
exec sp_addrolemember 'TheRole', 'SARAH'create view TestView
as select * from table1
inner join table2
on t1.id = t2.anotherid

grant select on table1 to TheRole
grant select on table2 to TheRole
grant select on TestView to TheRole

User SARAH can see the tables but not the view.

We're using SQL Server 2000 and Windows 2003 Server with ActiveDirectory.

Thanks
Timo