SQL Server Performance

User Access Rights on SQL Server

Discussion in 'General DBA Questions' started by fiddler, Oct 2, 2009.

  1. fiddler New Member

    Hi all,
    We are using a set of SQL tables with and Access 2003 front end for our major database. Our regular consultant is insisting that the users need full admin rights to areas of the server.
    I am saying No!
    We work by producing and .mde file which updates to a local users drive.
    The whole is launched by a .exe file, when a .txt file is changed on the server the update routine comes in to play automatically.
    If any dlls etc. need to be donwloaded these are also checked by the .exe file.
    I am hoping you are all going to say I am right and users do not get full admin rights on the server!
  2. Adriaan New Member

    I'm saying no too, at least for the server that is hosting SQL Server.
    Is it about having sufficient privileges for the folder where the EXE and TXT files are located? Then create a share for that folder, and set the user privileges on the share, rather than the actual folder.
  3. fiddler New Member

    Lovely, I need more of this agreement.
    It is the usual thing the consultant carries more wieght than the in house staff.
    Until it all goes wrong that is and then the question is so why did you allow it and it is hard to tell the boss 'you said so' and unproductive.

Share This Page