Re: Permissions

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 07:47:41 -0400

It appears that
1. The ERP may be using trusted connections. That would explain why things
can or can not be done based on who logged into the OS.
2. Also there may be some issues related to connection pooling.... When User
B logs into the OS and the ERP, then logs out of the ERP, the ERP continues
to behave as if userB was logged in... Either the ERP is somehow keeping a
connection open or perhaps the connection is not being re-initilized each
time it is returned to the connection pool... Check the connection pool
settings ( as per he ERP system documentation) and see if that helps... 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Robert" <anonymous@discussions.microsoft.com> wrote in message
news:22d0901c45db5$032581f0$a501280a@phx.gbl...
> 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
> -----------------------------------------------------------
>
> User A (Domain Administrator)
> User B (Domain User)
>
> 1 - User A logs into PC1 (Windows2K/XP). He then then logs
> into the ERP system. He can do everything he wishes as he
> has full domain admin rights.
>
> 2 - After user A is finished with the ERP system he logs
> out of the ERP system but leaves PC1 logged on. User B now
> opens the ERP system and logs in with his username and
> password. He can complete any task he attempts.
>
> THe PC is now logged off.
>
> 3 - User B now logs into Windows2K/XP on PC1 with his
> WIndows username and password and then logs into the ERP
> system. He can access all parts of the ERP as before but
> some screens fail to open/initilaize.
> He now logs off of the ERP in order that User A can log on
> but leaves Windows logged on.
>
> User A logs onto the ERP system and attempts to complete
> certain tasks. He can't seem to comlete them now either
> (Same taks).
> PC logged off
>
> 4 - Give User B admin rights and he can now achieve part 1
> of this scenario. Obviously it isn't appropriate to give
> every user on our network full Admin rights but does
> anyone know what could be happening here and where best to
> look for solutions? I.e Windows or SQL.

Relevant Pages

  • Re: Permissions
    ... The ERP may be using trusted connections. ... >B logs into the OS and the ERP, then logs out of the ERP, ... >Wayne Snyder, MCDBA, SQL Server MVP ... >> We use an SQL backend ERP system on our Windows Small ...
    (microsoft.public.sqlserver.server)
  • Re: Biztalk ERP integration questions
    ... Incoming orders from various partners in various formats (some XML, ... table in our ERP database; 2) generate new customer order number using ... and 2) import transactions into this ERP system given the 2 built-in ...
    (microsoft.public.biztalk.general)
  • Re: D3/NT - Auto logoff from inside ERP application ideas pls
    ... We can't afford to buy a whole heap of extra user licences for the ERP ... The ERP system comes with a menu program written in Pick Basic, ... after 10 minutes of inactivity. ... The ERP system has a locked items master file, ...
    (comp.databases.pick)