SQL views not accessible but tables are...

For some reason, an NT domain user is unable to see views in Access ADP. But
she can see the tables no problem. Is there a known issue with views? She
does have select permissions on the tables that underlie the view. Thanks in
advance for information or suggestions.
Timo

We're using SQL Server 2000 and Windows Server 2003 with Active Directory.
The connection string is using Integrated Security::

"Provider=sqloledb;Data Source=server1;Initial Catalog=ABC;Integrated
Security=SSPI;OLE DB Services=-2;"

Here are the steps I've taken with user permissions:

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

Database user SARAH can see the tables but not the view.


.

Relevant Pages

  • permissions mystery: ActiveDirectory issue?
    ... exec sp_grantdbaccess, 'SARAH' ... exec sp_addrolemember 'TheRole', 'SARAH'create view TestView ... grant select on table1 to TheRole ... We're using SQL Server 2000 and Windows 2003 Server with ActiveDirectory. ...
    (microsoft.public.sqlserver.security)
  • Re: permissions mystery: ActiveDirectory issue?
    ... So the problem has to do with the client application (Access 2000 ADP) ... > grant select on table1 to TheRole ...
    (microsoft.public.sqlserver.security)