Retrieve SQL Server data via MS Query to spreadsheet

Hi,
Here is a security question: what way can I restrict the access to SQL
Server 2005 database objects ?
I'm going to let some my users use some tables, views to create their own
MSQuery queries to retrieve data from SQLServer, but not all ones! (I have
hundreds of tables, views, sprocs...)
What is the bast practices both from server side and Excel-side for this
kind of restriction ?
Thanks,
szabtiBest thing is to create a special login in sql server and grant the user to
have permission only to those tables.
These permission depends on what all privileges you want to grant them, if
its simple select , them give only db_datareader access
vt
"szabti" <tibor.szabo@.iconsulting.hu> wrote in message
news:uANKaC4FHHA.5004@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Here is a security question: what way can I restrict the access to SQL
> Server 2005 database objects ?
> I'm going to let some my users use some tables, views to create their own
> MSQuery queries to retrieve data from SQLServer, but not all ones! (I have
> hundreds of tables, views, sprocs...)
> What is the bast practices both from server side and Excel-side for this
> kind of restriction ?
>
> Thanks,
> szabti
>|||szabti
Security is a huge subject especially in SQL Server 2005. I'd suggest to
spend a few days to study it .BOL is good place to start.
"szabti" <tibor.szabo@.iconsulting.hu> wrote in message
news:uANKaC4FHHA.5004@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Here is a security question: what way can I restrict the access to SQL
> Server 2005 database objects ?
> I'm going to let some my users use some tables, views to create their own
> MSQuery queries to retrieve data from SQLServer, but not all ones! (I have
> hundreds of tables, views, sprocs...)
> What is the bast practices both from server side and Excel-side for this
> kind of restriction ?
>
> Thanks,
> szabti
>