Databases
StackOverflow2013
Postsdbo
POHow can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
    primarykey
    data
    text
    <p>I've got an ms-access application that's accessing and ms-sql db through an ODBC connection. I'm trying to force my users to update the data <em>only</em> through the application portion, but I don't care if they read the data directly or through their own custom ms-access db (they use it for creating ad hoc reports).</p> <p>What I'm looking for is a way to make the data only editable if they are using the compiled .mde file I distribute to them. I know I can make the data read only for the general population, and editable for select users. </p> <p>Is there a way I can get ms-sql to make the data editable only if they are accessing it through the my canned mde?</p> <p>Thought, is there a way to get ms-access to log into the database as a different user (or change the login once connected)?</p> <hr> <p>@Jake,<br> Yes, it's using forms. What I'm looking to do is just have it switch users once when I have my launchpad/mainmenu form pop up.</p> <p>@Peter,<br> That is indeed the direction I'm headed. What I haven't determined was how to go about switching to that second ID. I'm not so worried about the password being sniffed, the users are all internal, and on an internal LAN. If they can sniff that password, they can certainly sniff the one for my privileged ID.</p> <p>@no one in general,<br> Right now its security by obscurity. I've given the uses a special .mdb for doing reporting that will let them read data, but not update it. They don't know about relinking to the tables through the ODBC connection. A slightly more ms-access/DB literate user could by pass what I've done in seconds - and there a few who imagine themselves to be DBA, so they will figure it out eventually.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USWill
    1. USBIBD
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
      1. USBIBD
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload