Re: Permissions

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 06/30/04 

Date: Tue, 29 Jun 2004 18:55:11 -0600

You really need to contact the vendor of the ERP. I couldn't
even start to guess on what "not function properly" would
mean and functioning properly or expected behavior would be
defined by the vendor of the ERP.

-Sue

On Tue, 29 Jun 2004 06:38:20 -0700, "Robert"
<anonymous@discussions.microsoft.com> wrote:

>One last thing i forgot to mention was that we had to
>change a network card and driver on the server and before
>this the parts of the ERP which do not function proplery
>now worked prior to the new card/driver being installed.
>
>Any advice/assistance in this matter greatly appreciated
>
>
>>-----Original Message-----
>>If a user who is a domain admin logs into SQL Server, if
>the
>>default BUILTIN\Administrators group has not been modified
>>or removed, the user will have sysadmin access through
>their
>>membership in the local administrators group on the SQL
>>Server - domain admins are members of the local admins
>group
>>and this group gets access to SQL Server through the
>>BUILTIN\Administrators group. The BUILTIN\Administrators
>>group are members of sysadmins.
>>How the security needs to be set up and how the users need
>>to be configured depends on the ERP system. You should
>>follow up with the vendor of this system to properly
>>configure security for the users of the system.
>>
>>-Sue
>>
>>On Tue, 29 Jun 2004 01:41:08 -0700, "Robert"
>><anonymous@discussions.microsoft.com> wrote:
>>
>>>We use an SQL backend ERP system on our Windows Small
>>>Business Server 2k network.
>>>The problem we have is this:
>>>
>>>Certain parts of the ERP don't work when logged in as
>>>Domain users, unless they have Domain Admin rights.
>>>
>>>Here is the scenario
>>>
>>>Pre-Requisites
>>>---------------------------------------------------------
>--
>>>Windows requires username and password
>>>ERP system requires username and password
>>>---------------------------------------------------------

Relevant Pages

  • Re: Just Ask The Vendor: Can OpenVMS Scale Down?
    ... I talked to one of the experienced guys, who told me that his experience was that ERP projects were more likely to be a success if the customer chose to adapt the organization to the ERP system and not the other way around. ... One reason is that ERP systems tend to support best business practice, and because of that adapting to the ERP systems meant dropping bad old customs and getting people to be more efficient without working harder. ... Well I'm sure that an ERP vendor would have such notions. ...
    (comp.os.vms)
  • Re: DBMS advantage and disadvantage
    ... ERP systems these UI's have undoubtedly been extensively customized by ... If the ERP vendor is small and only supports SQL Server 2000 then ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server Royalty
    ... I don't pay Microsoft any royalties on software that accesses sql server. ... It's just more profit these companies (the erp vendors) are trying to make. ...
    (microsoft.public.sqlserver.programming)
  • Re: DBMS advantage and disadvantage
    ... My company want to use database for ERP, ... Ask here and they'll tell you about SQL Server. ... Oracle and SAP. ... secret that SAP sells most of their systems on top of Oracle. ...
    (comp.databases.ms-sqlserver)
  • Re: DBMS advantage and disadvantage
    ... Ignore DA Morgan - he's the most anti-Microsoft person you will come across; he is very very anti SQL Server because he knows full well that it's beating Oracle up left right and centre in the BI and RDBMS market on the Windows platform - the platform of choice for most businesses. ... The Microsoft product set you are talking about for ERP is Microsoft Dynamics. ...
    (comp.databases.ms-sqlserver)