用户解锁教学

《用户解锁教学》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、燈SQLPios••SQL>SELECTusernane.dueount.statusl?ROf1dba_users；IIHIHNAMLACCOUNT.STArUSKGIT1_UIliWSVSSVSTEMDBSNMPSVSMANOUTLN11OWS」1LEUMDSYSOR册SEXFSVSWMUYSOPENOPENOPENOPEHOPENEXPIREDEXPIREDEXPIREDEXP1HEDEXP】REDEXPlMED&LOCKED&LOCKED&LOCKEDBiLOCKED去LOCKED&LOCKEDIISb

2、HNAMLACCOUNT.STfifUSWKSYSWKTESTCTXSYSnNOMVMOUSXUB'..'KPROX?EXPIHED&EXPIRED&EXPIHED&EXPIRED&EXPIHED&EXPIRED&LOCKEDLOCKEDLOCKEDLOCKEDLOCKEDLOCKED用户解锁与数据插入1.用户解锁的方法昌SOLPlus用户system输天口令二狂或到：.□racleDal

3、ePartitioning,OLAP.DataMiningAndRealApplicationTestingoptionsRQb>SELECTinstance«namc■host_namcFPOtlv^instnnee:IHSTANCE_XftMEnrclWHhRQL>COLUrtNhosMmneFORMATA2RSQL>/1HSTANCE_HAMEHOST.NAME□rclUHMSQL>SELECTut;ertiafie>aucou

4、OPEHOPENOPENEXPIREDEXPiNEDEXPIREDBXPIHEDEXPIREDSQL>ALTERUSERscottIDENTIFIEDBYtiger;冃户己更改。SQL>SELECTusernane•accountstatusFBONdbauser^;USERNAHEACCOUNTSTATUS&USEBNAMEACCOUNTSTATUSEXPIRED&LOCKEDLIMCVQprIwOJOLOCKEDLOCKEDLOCKEDLOCKEDLOCKEDSQLPln«MGMTUIEWSYSBVSTEt

5、lDBSNMPKVSHAMfcsCOTTk>IJTLNtt-LO»JS.FILESMDSYSOKDSYSEXFSVS2、用户信息的插入向表屮插入数据方法，简单示例；Insertintoempvalues^1T张三J；3、数据的查询Selectusername,account_statusfromdba_users;Selecttable_namefromuser_tables;Select99*84;