Permissions

From: Robert (anonymous_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 01:45:01 -0700

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

  • Permissions
    ... We use an SQL backend ERP system on our Windows Small ... unless they have Domain Admin rights. ... - After user A is finished with the ERP system he logs ...
    (microsoft.public.sqlserver.server)
  • Permissions
    ... We use an SQL backend ERP system on our Windows Small ... unless they have Domain Admin rights. ... - After user A is finished with the ERP system he logs ...
    (microsoft.public.sqlserver.security)
  • Re: TravelinMan gets hoisted on his own petard!
    ... And even if you could, why would your imagined source be any more believable than CNN, the SEC, or Fox News? ... You admitted here that your salesmen all use Windows, and that you spent "many, many thousands of dollars" to secure your Windows network. ... If you're choosing what 'the company runs on', that would be the ERP system or perhaps the finance system. ...
    (comp.sys.mac.advocacy)
  • Re: Ruby on Linux & Windows
    ... Well, the main reason for the switch was because the project I had handed to me was to be written inside of the new ERP system we are implementing, which requires Windows on the client. ... I was rather disgusted with the technology, though, and found a way to avoid that mess by doing a web app and tying into the client via a browser component. ...
    (comp.lang.ruby)
  • Re: Permissions
    ... If a user who is a domain admin logs into SQL Server, ... to be configured depends on the ERP system. ...
    (microsoft.public.sqlserver.security)