环境:Linux服务器,oracle用户下安装了oracle10g; windows XP客户端,安装SecureCRT;
1,使用 SecureCRT 连接到数据库服务器;
2,执行: su - oracle/oracle;
3,执行: sqlplus / as sysdba;
4,执行:创建用户userName/password ,并授权
create user userName identified by password default tablespace users temporary tablespace temp ;
grant connect,resource,create view, unlimited tablespace to userName ;