transport

[Former Member]

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.

[Former Member]

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]

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]

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]

Hi abdul,

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

Reg'

Zeemaaaa

[Former Member]

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