Re: SQL Server - Enterprise Manager
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: Sat, 20 Nov 2004 20:44:32 -0000
Just giving people access to these is probably quite dangerous regardless of
security! You may be violating your warantly? I would expect the payrole
system to provide an interface of some sort for you to programme against and
to return data that is consistent and will not block important transactions.
The (EM) users access to the tables be determined by the access of the user
that the server is registered with.
"Lavan" <firstname.lastname@example.org(donotspam)> wrote in message
> 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
> 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
> protect the "payroll tables" allowing the programmers access to the
> 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
> Thanks for your assistance!
> L. Robertson