Re: ODBC Table Protection
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 06/30/03
- Next message: Bosko Maksimovic: "Re: Security Baseline Analyzer"
- Previous message: Tina: "ODBC Table Protection"
- In reply to: Tina: "ODBC Table Protection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 30 Jun 2003 17:30:38 -0400
It doesn't matter what they use to access the database. They have to login
in to the server some how and then that login is linked to a user in the db.
You control access via the permissions on the Logins and users. If you
don't want them to access a particular table then deny that user access to
the table. Or better yet place the user(s) in a custom role and set the
permissions at the role level.
-- Andrew J. Kelly SQL Server MVP "Tina" <tlevensky@nordicenergy.com> wrote in message news:038a01c33f45$e450cde0$a301280a@phx.gbl... > I'm very new to SQL server and I've been doing a ton of > reading but have not come up with a good solution for > this issue. I have an application that uses SQL db and > within the application, I can limit access to tables, > forms, etc. However, we need to do reporting off of the > SQL data but I don't want everyone to access all tables. > I'm thinking of using an ODBC driver with Access as that > is what the programmers are familiar with, but how do I > protect data via ODBC? Any suggestions would be much > appreciated!!!
- Next message: Bosko Maksimovic: "Re: Security Baseline Analyzer"
- Previous message: Tina: "ODBC Table Protection"
- In reply to: Tina: "ODBC Table Protection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
