Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

transport

Former Member
0 Kudos

Hi All,

i have some questions please answer this.

1) could u give me the sql query to delete sap*

2)when we EXPORTclient we get KO,KT,KX, files which file should beIMPORT first.

3)how to creat profiles (i need the prosidure)

i will be thankful to u please.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

delete sap*

example SQL:

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

restart and use pass if parameter is set to 0

login/no_automatic_user_sapstar= 0

question 3

create profiles using transaction SU02 search on this and you can find info however most access is created using transaction PFCG these days

4 REPLIES 4

Former Member
0 Kudos

delete sap*

example SQL:

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

restart and use pass if parameter is set to 0

login/no_automatic_user_sapstar= 0

question 3

create profiles using transaction SU02 search on this and you can find info however most access is created using transaction PFCG these days

Former Member
0 Kudos

Hello Abdul,

Benjamin has answered 1 and 3rd question so I will only answer 2nd one. Import order is not critical here as all the three transports contain different objects. Check this link for more clarity:

http://help.sap.com/saphelp_nw04/helpdata/en/69/c24c824ba111d189750000e8322d00/content.htm

Regards.

Ruchit.

Former Member
0 Kudos

Hi abdul,

Send me ur mail id..I wil send u the procedure for creating a profile..

Reg'

Zeemaaaa

0 Kudos

thank u my mail id is <b><removed by moderator></b> and please send some BASIS material also thank u verymuch.