RE:[sap-basis] Dump duplicated record when creating a new user
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Steve99 on May 3 at 2:33 PM |  Mark as helpful |
yes...you could delete if confirm that this user should be deleted from the db. use the select statement
SQL> delete from SAPR3.USR02 where MANDT='<client_xxx>' and BNAME='<name>';
SQL> update SAPR3.USR02 set UFLAG='0' where MANDT='client_xxx' and BNAME='<name'';
SQL>commit;
this should delete user from table and update it..
---------------Original Message---------------
From: Pedro de Paula
Sent: Monday, May 03, 2010 2:07 PM
Subject: Dump duplicated record when creating a new user
> Hi all. What's happening is this.
>
> I'm want to create a "new" user but when I save after put all datas like (name, password...), I receive a dump SAPSQL_ARRAY_INSERT_DUPREC. If I try to remove the same user the system response that doesn't exist this user. It's happening for only one user.
> I saw in some tables (USR21, USREFUS) that there is a record with user but in USR02 it's not true, there isn't this user.
>
> I would like to know if we can remove, with any program or function, those entries from the tables where its exists and recreate the user.
>
>
> Thanks for your help.
__.____._ SQL> delete from SAPR3.USR02 where MANDT='<client_xxx>' and BNAME='<name>';
SQL> update SAPR3.USR02 set UFLAG='0' where MANDT='client_xxx' and BNAME='<name'';
SQL>commit;
this should delete user from table and update it..
---------------Original Message---------------
From: Pedro de Paula
Sent: Monday, May 03, 2010 2:07 PM
Subject: Dump duplicated record when creating a new user
> Hi all. What's happening is this.
>
> I'm want to create a "new" user but when I save after put all datas like (name, password...), I receive a dump SAPSQL_ARRAY_INSERT_DUPREC. If I try to remove the same user the system response that doesn't exist this user. It's happening for only one user.
> I saw in some tables (USR21, USREFUS) that there is a record with user but in USR02 it's not true, there isn't this user.
>
> I would like to know if we can remove, with any program or function, those entries from the tables where its exists and recreate the user.
>
>
> Thanks for your help.
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
