Table DEVACCESS overwritten

[chris55]

My site has recently taken a complete clone of the production system and set up a new developement system based on it. Amongst other things the table DEVACCESS holding developer keys has been overwritten. I now find that my user ID is missing from this table, but I still have development access. Where is the table/flag or whatever that controls this? I'm assuming there's a flag somewhere against my user ID that says I am a developer and that no reference is made to DEVACCESS when I carry out development activities. Can someone explain - and is it possible to retrieve my developer key?

Version 4.7.

Thanks,
Chris.

[thx4allthefish]

I have no system-access today - but I have been wondering about the same thing, when we made our copies for the Chinese systems. I'll investigate tomorrow and come back, if I find the solution.

[chris55]

Thanks. Hopefully you can find something out. I've looked at all the usual suspect USR tables but can't find anything.

[thx4allthefish]

I have no explanation for the phenomenon on your system.

What I found is, that this key is stored only in table DEVACCESS and nowhere else. When you try to change a repository object for the first time, a kernel-C-function DEVELOPER_KEY_CHECK is called (function group SKEY - try SE80 for more details) which verfies your entries agains DEVACCESS.

I have been checking this on ECC 5.0 and 6.0 and there's no difference, so I think it is safe to assume that it works exactly the same way in 4.7 ... which leaves your case a mystery, sorry.

[chris55]

Thanks Fish, I guess it will remain a mystery - strange one though.

[jurjen]

Now I am curious about the 'real' emptyness of DEVACCESS. Does it look empty from within SAP or does a direct database query also return an empty result set?

[chris55]

I used SE16 to query the table, so that should show it pretty much as it is.