Ansicht
Dokumentation

13343 - Antwort: SQL error "-551" occurred when accessing table "AGR_USERS ".

13343 - Antwort: SQL error "-551" occurred when accessing table "AGR_USERS ".

Addresses (Business Address Services)   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Antwort: SQL error "-551" occurred when accessing table "AGR_USERS ".


Udo

Yes - no problem to start QN2 now, but I see a lot of ABAP runtime errors
DBIF_RSQL_SQL_ERROR..........??

Regarding authority and owners I have some objects in the DB witch still
have QDFTOWN and was not changed by FIXR3OWNS or AS4FIXFILE

**************************************************
Per-Lennart Andersson
Coca-Cola Drycker Sverige AB

Tel +46 8 5007 5057 Mobil +46 70 320 5743






"Udo Wiedel"

<uwiedelZlitte To: <DoNotReply@consolut.eu>

lfuse.com> cc:

Subject: RE: Antwort:
SQL error "-551" occurred when
2004-03-12 accessing table "AGR_USERS ".

21:14

Please respond

to

SAP on System i









Works also..

-----Original Message-----
From: Per-Lennart Andersson [mailto:peranderssonZc...]
Sent: Friday, March 12, 2004 9:43 AM
To: DoNotReply@consolut.eu
Cc: DoNotReply@consolut.eu
Subject: RE: Antwort: SQL error "-551" occurred when
accessing table "AGR_USERS ".



Udo

Of corse - stupid me....  thanks, but I took sidOWNER as owner.

Regards and nice weekend

**************************************************
Per-Lennart Andersson
Coca-Cola Drycker Sverige AB

Tel +46 8 5007 5057 Mobil +46 70 320 5743




                    "Udo Wiedel"
                    <uwiedelZlitte       To:
<DoNotReply@consolut.eu>
                    lfuse.com>           cc:
                                         Subject:     RE: Antwort:
SQL error "-551" occurred when
                    2004-03-12            accessing table "AGR_USERS ".
                    16:30
                    Please respond
                    to
                    SAP on System i






1.      GRTOBJAUT OBJ(R3xxxDATA/*ALL) OBJTYPE(*ALL) USER(R3OWNER) AUT(*ALL)



Udo

-----Original Message-----
From: Per-Lennart Andersson [mailto:peranderssonZc...]
Sent: Friday, March 12, 2004 9:15 AM
To: DoNotReply@consolut.eu
Cc: DoNotReply@consolut.eu
Subject: Re: Antwort: SQL error "-551" occurred when
accessing table "AGR_USERS ".



Hi Thomas

Yes it was "dftown" how was the owner and some more and it's not fixed by
FIXR3OWNS. As I understand FIXR3OWNS just fix owner problems in the Kernel.
I need something that change owners in R3sidDATA.

/ PL

**************************************************
Per-Lennart Andersson
Coca-Cola Drycker Sverige AB

Tel +46 8 5007 5057 Mobil +46 70 320 5743




                    thomas.kremmin
                    Zseeber.de           To:
DoNotReply@consolut.eu
                                         cc:
                    2004-03-12           Subject:     Antwort:
SQL error "-551" occurred when
                    14:30                 accessing table "AGR_USERS ".
                    Please respond
                    to
                    SAP on System i




Hi Per,

looks like an authortiy problem.
Look at the file at OS level DSOBJAUT.
<SID> owner should be the owner.
Authorities:
*GROUP  <SID>OWNER              *ALL
*PUBLIC                         *CHANGE (Don't know if this is OK? Perhaps
it have to be *EXCLUDE ?)


Best regards / Mit freundlichen Grüßen

Thomas



"Per-Lennart Andersson" <peranderssonZc...>
12.03.2004 14:15
Bitte antworten zu
DoNotReply@consolut.eu


An
DoNotReply@consolut.eu
Kopie

Thema
SQL error "-551" occurred when accessing table "AGR_USERS
".






Hi all of you!

I got the following immediately then I start R3 after an refresh of QN2. I
have done it several times before but now something went wrong. I use the
concept from "files".

After I have run AS4FIXFILE, DLTR3PKG and also FIXR3OWNS. We are "very
close" to the infoapar and on 46C with kernel 1768

Do anyone know??

ABAP runtime errors    DBIF_RSQL_SQL_ERROR
SQL error "-551" occurred when accessing table "AGR_USERS ".

How to correct the error

Database error text........: "Not authorized to object AGR_USERS in
R3QN2DATA
type *FILE. Job=117626/QN202/WP00"
Internal call code.........: "[RSQL/OPEN/AGR_USERS ]"



Regards

**************************************************
Per-Lennart Andersson
Coca-Cola Drycker Sverige AB

Tel +46 8 5007 5057 Mobil +46 70 320 5743





Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu




consolut Links

To visit your group on the web, go to:
http://groups.consolut.net/group/SAP on System i/

To unsubscribe from this group, send an email to:
DoNotReply@consolut.eu







[Non-text portions of this message have been removed]



Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu


                                consolut Sponsor
                                        
                                            [IMAGE]
           [IMAGE]




consolut Links

   To visit your group on the web, go to:
   http://groups.consolut.net/group/SAP on System i/

   To unsubscribe from this group, send an email to:
   DoNotReply@consolut.eu

  








Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu



  _____

consolut Links


*      To visit your group on the web, go to:
http://groups.consolut.net/group/SAP on System i/


*      To unsubscribe from this group, send an email to:
DoNotReply@consolut.eu <
mailto:DoNotReply@consolut.eu?subject=Unsubscribe>


*      Your use of consolut is subject to the consolut Terms of Service
< http://www.consolut.net> .




[Non-text portions of this message have been removed]



Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu


                                consolut Sponsor
                                        
                                            [IMAGE]
           [IMAGE]




consolut Links

   To visit your group on the web, go to:
   http://groups.consolut.net/group/SAP on System i/

   To unsubscribe from this group, send an email to:
   DoNotReply@consolut.eu

  








Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu



consolut Sponsor


<
http://rd.consolut.net/SIG=12cmo3tb8/M=266841.4700596.5858952.1261774/D=egroupweb/S\
=1705123219:HM/EXP=1079192636/A=2026346/R=0/SIG=12473cbsu/
*http://www.lifescapei\
nc.com/picasa/landing.php?capid=314&caId=2343

> click here
  <
http://us.adserver.consolut.net/l?M=266841.4700596.5858952.1261774/D=egroupweb/S

:HM/A=2026346/rand=155322867>


  _____

consolut Links


*      To visit your group on the web, go to:
http://groups.consolut.net/group/SAP on System i/


*      To unsubscribe from this group, send an email to:
DoNotReply@consolut.eu <
mailto:DoNotReply@consolut.eu?subject=Unsubscribe>


*      Your use of consolut is subject to the consolut Terms of Service
<http://www.consolut.net> .




[Non-text portions of this message have been removed]



Have a look to our homepage at: http://www.EasyMarketplace.de
DoNotReply@consolut.eu




consolut Links

To visit your group on the web, go to:
http://groups.consolut.net/group/SAP on System i/

To unsubscribe from this group, send an email to:
DoNotReply@consolut.eu









Durban Tours - Südafrika Safari

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 17396 Date: 20240329 Time: 004921     sap01-206 ( 4 ms )