User Authorisations do not work When Applied

[Former Member]

Dear Experts,

I have a situation here that is quite baffling. I go into user authorizations, set full authorizations on the sales module for a user. Then click update, the system does not update automatically and I have to click the update button twice. Once I close the authorizations window and open it again the authorizations previously set have gone back to what they were before. This is happening for all users.

Does anyone know what could be causing this ?

[Former Member · Accepted solution]

Hi,

Some other users post the same issue before. What is your B1 version and PL? Have you checked the other threads not long times ago?

Thanks,

Gordon

[Former Member · Accepted solution]

I have checked but haven't found anything. Am using SAP 8.81 PL06.

[Former Member · Accepted solution]

Hi MARTIN,

You have to done authorization as Super User?

Thanks,

Srujal Patel

[Former Member · Accepted solution]

Hi Guys,

There is SAP Note : 1315424. Problem is, I can't access this note. Any ideas on how I can get to this ?

[Former Member · Accepted solution]

Hi Martin

In this Note details are as under

Symptom

You open the General Authorization Window (Administration -> System Initialization -> Authorizations). You update some authorization for a specific user and press the Update button.
There is no response, the update does not take place but no error appears.
If you try to press the Update again, a success message appears but the update is not saved.

This issye might occur if in the User Authorization table (USR3) there are authorizations that do not appear in the Additional Authorizations table (OUPT).

Cause

Specific Solution

Solution

In order to verify if your database is affected by the issue above, run the following select query:

Query for version 8.8:
select distinct PermId from USR3
where
permid not in (select absid from OUPT) and
permid not in (select distinct cast(PermId as nvarchar(50)) from CDPM)

Query for versions 2005 and 2007:
select distinct PermId from USR3
where PermId not in (select absid from OUPT)

If the select query above retrieves results, the solution to this note can be delivered via the Remote Support Platform for SAP Business One.
Please refer to RSP task No. 1569886 to solve the above mentioned issue.

Other terms

Permission, OUPT, Hang, Authorized, User, Super, Response, React


Header Data
	
Released on 	28.03.2011 12:48:27
Release status 	Released for Customer
Component 	SBO-ADM-INI-AUT Authorizations
Priority 	Correction with high priority
Category 	Program error

References

This document refers to:
SAP Business One Notes
1502270 	  	Solution via Remote Support Platform for SAP Business One

Validity
Software Component
	
Version
SAP BUSINESS ONE
	
2005 A SP01
2005 B
2007 A
2007 B
8.8

Thanks,

Srujal Patel

[Former Member]

Hi!

Try once, closing all other user conncetions and addon's.

Ensure your server is not connected by other user. Stop all services except License Manager

Ensure, No SAP service is running by other users - Task Manager

Open SAP as a Super User, SET the Authorization and check

[Former Member]

Hi MARTIN,

1. If Add-on are runing in your system then First Stop Add-on One by one and check it in which Add-on you have problem.

2. If SP are runing in your system then Stop SP one by one and check it in which SP you have problem.

After it restart all SQL Services in Service.msc and try again.

After it no solution get then upgrade your PL OR Version and try again.

Thanks,

Srujal Patel

[Former Member]

Dear Martin,

Stop you all add-on and restart restart the system and try again.

Because many cases add-on affected standerd fucntinality

Otherwise its a Patch bug so try to upgrade your patch.

Regards

MANGESH PAGDHARE.