Re: permissions mystery: ActiveDirectory issue?
From: Timo (Timo_at_unspam.biz)
Date: 06/23/05
- Next message: pigeon: "Port 1433 is open to internet, how can I secure db?"
- Previous message: Timo: "permissions mystery: ActiveDirectory issue?"
- In reply to: Timo: "permissions mystery: ActiveDirectory issue?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 23 Jun 2005 14:22:48 -0400
I've installed Query Analyzer on the user's desktop, and she CAN see the
view. So the problem has to do with the client application (Access 2000 ADP)
and/or ActiveDirectory. Our domain admin put the Access 2000 ADP on his PC
and he can see the view fine.
Timo
"Timo" <Timo@unspam.biz> wrote in message
news:eRc2XxAeFHA.2420@TK2MSFTNGP12.phx.gbl...
> 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
>
>
- Next message: pigeon: "Port 1433 is open to internet, how can I secure db?"
- Previous message: Timo: "permissions mystery: ActiveDirectory issue?"
- In reply to: Timo: "permissions mystery: ActiveDirectory issue?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
