SQL Server - Enterprise Manager

From: Lavan (mlrobertson_at_compdatasurveys.com(donotspam))
Date: 11/19/04

  • Next message: Richard Roche: "is there a way to disable a database role?" 
    Date: Fri, 19 Nov 2004 13:19:04 -0800

    Our accounting package is ACCPAC Corporate Series running on SQL Server 2000.
     We want to allow our programmers access to the accounting A/R data base
    tables to create custom applications for our accounting and sales depts
    (in-house CRM popgram).

    The problem we will have and would like to resolve is the following:
     
    By using Enterprise Manager we are "back-dooring" our Accounting system
    security and the programmers would have access to "all of the accounting
    database tables".

    We would like to know if there's a way within Enterprise Manger to password
    protect the "payroll tables" allowing the programmers access to the remaining
    tables.

    In a nut shell - does Enterprise Manager have the capabilitiy to restrict
    access to the database tables on a table-by-table basis? If so, how is it
    done.

    Thanks for your assistance! 

    -- 
L. Robertson
  • Next message: Richard Roche: "is there a way to disable a database role?"

    Relevant Pages

    • Re: SQL Server - Enterprise Manager
      ... trying to do is best accomplished using applications roles and ANOTHER ... > Our accounting package is ACCPAC Corporate Series running on SQL Server ... > We want to allow our programmers access to the accounting A/R data base ... > We would like to know if there's a way within Enterprise Manger to ...
      (microsoft.public.sqlserver.security)
    • Re: Looking for inventory management and invoicing programs
      ... > Good point Rick, but I think most of the problematic issue with Y2K related ... Accounting program used 4 digits for data in the year ... Database program generated "automatic dates" using Julian ... It simply went nuts trying to report dates after 12/31/1999. ...
      (comp.sys.tandy)
    • Re: Simply Accounting
      ... It actually turns out that simply accounting uses ms-access files (and the ... counting uses the same database format as ms-access. ... also, and if you don't join that workgroup file, then you'll not be all to ... Dim strTables As String ...
      (microsoft.public.access.modulesdaovba)
    • Re: Accounting with Ms Access
      ... I have successfully integrated Access databases with People's Choice ... Accounting which is written in Access: ... PurchaseOrder table and forms all based on the Northwind Sample Database. ... programmer or accountant so the chance of me doing something wrong is ...
      (microsoft.public.access.forms)
    • Re: Setting the Appropriate Trial Time for Shareware
      ... program is database centric. ... > Shane, the database has a field with the version number and this is used ... > which for our type of program (accounting) is essential. ... > BS/1 Accounting, Time Billing, Distribution, and Manufacturing Software ...
      (borland.public.delphi.thirdpartytools.general)