06-28-2007 9:13 PM
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.
06-28-2007 9:32 PM
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
06-28-2007 9:32 PM
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
06-28-2007 9:39 PM
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.
06-29-2007 6:24 AM
Hi abdul,
Send me ur mail id..I wil send u the procedure for creating a profile..
Reg'
Zeemaaaa
06-29-2007 11:11 AM
thank u my mail id is <b><removed by moderator></b> and please send some BASIS material also thank u verymuch.