在10g以后用默认用户名密码scott/tiger/orcl登陆创建新用户:
create user test1 identified by test1;
grant connect,resource to test1;
用test1登陆:
sqlplus test1/test1
首先用管理员的帐户登录(要有修改用户的权限)system
alter user sys identified by 123; (sys是用户名,123是密码)
如果用sys登录:
connect sys/oralce as sysdba;
用system登录:
connect system/oracle;