oracle命令行删除用户：

代码如下:connect/assysdba;
shutdownabort;
startup;
dropuseruser1cascade;
exit

oracle命令行创建用户：

代码如下:createuseruser1
identifiedbyvalues’fa091872a2cc669c’
defaulttablespaceuser1
temporarytablespacetemp
profiledefault
accountunlock;
–4rolesforuser1
grantrecovery_catalog_ownertouser1withadminoption;
grantresourcetouser1withadminoption;
grantdbatouser1withadminoption;
grantconnecttouser1withadminoption;
alteruseruser1defaultroleall;
–3systemprivilegesforuser1
grantselectanydictionarytouser1withadminoption;
grantunlimitedtablespacetouser1withadminoption;
grantalteranyproceduretouser1withadminoption;