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;