lostexchange
Technical User
Hi, I need help from a SQL guru. We have a very important program that runs on a sql 2000 sp3 server. The application front end connects via ODBC to SQL. We have 4 areas that log into the same database and access different parts of the database for thier area. The auth is via SQL. Our problem is now we are are looking at running reports and we notice that via excel, crystal etc we can connect via odbc and see everything (and update anything) in the database no matter who we are logged in as. So for security reasons and data protection this is not good. There is sensitive data in there. We need people to only be able to see the area of the database that they can see while in the application. I am not sure I am making sense - I am not a sql guru. Is there a tool I can use that will limit what users can see via odbc when running reports.
Thanks for any help you can offer!
Thanks for any help you can offer!