create user user_name
identified by user_pass
quota 1000m on default_space
quota 50m on system
profile user_profile
password expire;
identified by user_pass
quota 1000m on default_space
quota 50m on system
profile user_profile
password expire;
调试欢乐多
connect sys/manager as sysdba;
create user test identified by test;
grant dba to test;
conn test/test;
create table test(
code varchar2(10);
name varchar2(20));
/
在Oracle中,只有写sql或者通过其他的工具来建表,添加用户可以在oracle的安全管理里面作。