NC账户被锁定
NC上的用户,不管是管理员,还是用户,都是统一存放在同一张表的,不像NCC 一样有sm_super_user这张表,用来区分。
所以在NC上一视同仁就好了。
以下有两种常用的修改方式
一、数据库修改
nc65用户被锁定后涉及到三张表 cp_user 、sm_user_ex、sm_user,其中sm_user_ex和sm_user这两张表只用更改 islocked 的值就好了(一般只需要sm_user_ex表修改就可以,具体看一下对应的值),而cp_user 需要删除当前用户 exstatuscode 为1 或为2 的数据 //1是被管理员锁定的 2是用户自行锁定。
例如:user_code =‘13608872550’ user_id = ‘1001A1100000000146CN’ 的用户进行解锁和修改密码
1.解锁:
第一步:查表sm_user_ex ,查看这个用户被锁定的记录,并删除这条数据。
select * from sm_user_ex where user_id = '1001A1100000000146CN'//查询SQL
delete sm_user_ex where user_id = '1001A1100000000146CN' //删除表里面的数据
第二步查表cp_user,更改状态。
select * from cp_user where user_code ='13608872550'
update cp_user set islocked='N' where user_code ='13608872550';//修改状态
2.修改密码:
update sm_user sm set sm.user_password='U_U++--V'||LOWER(RAWTOHEX(UTL_RAW.cast_to_raw(sys.dbms_obfuscation_toolkit.md5(input_string=>sm.cuserid||'1'))))
where sm.user_code ='13608872550';
修改密码为"1"
也可更改sm.cuserid||'1' 上1的值 ,可自行尝试
第二种是通过配置文件设置root用户的密码为空,然后一层一层的往下改。
找到home路径下的\home\ierp\sf
一般最好是找root为空的home复制一下 ,或者也可以直接下载 或者把之前的备份后,把以下内容替换。
iccpkbancpkccmbaejmicpkaehagbnfbkhmdfkloiedjpoihpgckikcehhkofficeedggdlahcfkchgkmjlgdbemnibalnpmdancalmkiolbbbpdmiepdfjcogcfhomhjhhhpcoaindneaijjfhajgdedeledgmdboigjjopmbgalpjpifigeggmnikildhldpggfoibgikpijbcccegkjgciilmmjkhcbhjfjlkcabnnbemebijmocndgkbdeiafbmaofkandopmapjinkhnjedmkmjmkbhpbehalgmniomahoeejoblfonebeibmndcekllfgmdfldajoojijihfeeffaodfpldkhlnlbclffefncmejikjggieaojfbngjniikkcagdabiipgnecnadjdfoojapnjbggchokejigibggehbhiibflodbgcnfokicihmnapdpljnlgoiaallnoccaiolghhggbcijnaaiondhejdhbfmmnebfmbijhdbcllpbeeciibeblghgcjnnglppodniflnhdbekdkomgklkjlhdhbabdndlpglpodcceljhoajpbdibmkghhpfcnaolobbjncijlmdmfcmlfbnklgkbkmabkadojfdipkliloigpabegnndpflkmjbpejeophonfmmolgocdjfidcpimifhegikkkjbomjejhpnegeglfoaadhnfophpnpjcnmdmonfkjifmgobhcnhcbilojjelghkpeemibfgdblknlhbcphdehfhgjaiofepffgnejlbjpdlddfefohpkmncjjfhajgdedeledgmdlmnddalomlnnjnldgomcmncilfomamlmebhbhcbickfnhgkkfjcfogloedjpapoknpgkbmcdnamoofmhdnhodconlhoeejaebclkhcfjobbncnjcbhaneheljpnifeobkecpkiamennemickndhbpgenccbjikblhcmflnoienfmhjckffibhbndccflibiedjfgdldoapppjalmiplddiphblhniekhhhcnhbmaegjkcmklcchiiddhbbppakefhhgogdbcpijohbibfjfpfajdnbjnegghmojakedncpjdbnnjmjgjghganndhjjkagfnhhaadnknejdbdkodjfkilaameoeagofmjfpnhdobodokolofbidepeknjemodfkjdlpoeajiicglneoanffnfdelccdpdpdmfgjiboahfhenhegnhmegmmnnagabdpcncdfpofedagplomajfnaoeacemmcfbijbkaofbiooahmmfbpmcgjmodlidaagmpfnffgdgpflclilddancalmkiolbbbpdgnaohaahgojmaijohmbccedbbbdfiecknnmmcdnhgppoefgajjkehgmfngebdbhodbeggnopdjagljgnifigeggmnikildhldpggfoibgikpijbcccegkjgciilmmjkhfmphnmncjdppplhdkihceiaokpjlncjafndmggmjfmcfdnddhhgppdfknbdggpjgafcldiempinegajcejoblfonebeibmndcepoohbpgngocmmlbggchokejigibggehbhiibflodbgcnfokicihmnapdpljnlgoiaallnoccaiolghhggbcijnaaiondhejdhbfmmnebfmbijhdbcllpbeeciibeblghgcjnnglppodnifegdakmhdidaejccjebgmihlinbjjmkhadcceljhoajpbdibmnlgbjhkonhgdkfepbfgnnbcbfkeonfbcfilmkgggdhbidchalogfnjnkibaigjjgphkiohgjejhbffelpghfcmifbgjoninkdfonplnhjkajiekdilgddaeehmihjfepegoeecbbiplhacfgpdfgnaddcnlmbdifhojccocnkjailfmljhfhmcglmnfbjboippbnaloblbjankmacaihbajbkbghoanplkamifjnocijbbjadinbnlmcklhjpafjooklmkdmnepldeabfamegfnekjiniaailbelmneajpjbopdobijmpcgobkgdehbhoamfkaljpdmhfkhnpbffkdfmjkiflkngajbdelkdlhlcemblllmkgbdbkjedodkabllfjlhoikamhbdcgfmdjmklhmohbgbpcchiiddhbbppakefjlfedjaoibekodcfalkkbkbhhofgjokecdallbpjcckepdmnipnaloijhcgebbnahbhiibflodbgcnfoomlhdjpckfpgpolmpnnpcejioommdlnhdkkodghbkabmhlgeildnbjmmakoiifefgghdoddpkmhnkfdkbbgohooimipaodjgcnkcpdkmohhpikhipcnpkcngfjmmdkdljjniajonbpbeigfkfhenbepelgaddjliciebgggcbgphonkhnhmbmdalijglefigmegkhopnkblomiaeeeifpamighgadihoiokpggecgabgldidpleefggnnllamkmcmmjpnofgggpdbhfjooplhpfmlambphjj
NCC账户被锁定
NCC修改管理员密码
update sm_super_user set password='U_U++--V93f182df06984208361b9689a94416ec' where admcode ='root';--重置为空密码
update sm_super_user set islocked='N' where admcode ='root';--如果用户锁定,运行该命令进行解锁
NCC解锁root用户
NCC解锁账户需要到oracle后台进行解锁,PK视情况而定
update sm_super_user
set ISLOCKED='N'
WHERE PK_SUPER_USER='INITA910000000000001'
到oracle后台进行解锁,PK视情况而定
update sm_super_user
set ISLOCKED=‘N’
WHERE PK_SUPER_USER=‘INITA910000000000001’