We have been using MS Query from Excel to collect info
from our SQL Server. However, there is no limit on what
tables we can use. Before we distribute this product
to managers around the company, we need to assign rights
to them.
What is the best way to do this?
When setting up an ODBC connection on each computer, we
do use the same name and password for every one. Can we
lock down access rights for that name and password on
our server?
I would appreciate any help anyone could give us.
Thank you.
from our SQL Server. However, there is no limit on what
tables we can use. Before we distribute this product
to managers around the company, we need to assign rights
to them.
What is the best way to do this?
When setting up an ODBC connection on each computer, we
do use the same name and password for every one. Can we
lock down access rights for that name and password on
our server?
I would appreciate any help anyone could give us.
Thank you.
