Re: SQL Server - Enterprise Manager

From: Dennis Redfield (dennis.redfield_at_acadia-ins.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 09:08:40 -0500

in general using EM is for administrative functionality. What you are
trying to do is best accomplished using applications roles and ANOTHER
INTERFACE completely.

dlr

"Lavan" <mlrobertson@compdatasurveys.com(donotspam)> wrote in message
news:3503EEFD-93B1-499F-BF65-28F82234CDA7@microsoft.com...
> 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