Friday, March 30, 2012

Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
ThanksThis is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks
>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
>> If we want someone to use Query Analyzer only - allow
end
>> user to run query by themselves, is it necessary for us
to
>> install "Client Connectivity" on that machine as well?
>> Thanks
>
>.
>sql

No comments:

Post a Comment