oracle之创建用户及登陆

Oracle有3个默认客户

1、sys 密码change_on_install [as sysdba]

2、system 密码manager

3、scott 密码tiger

 

用cmd登陆：sqlplus / as sysdba

 

创建用户：create user xiaokuidentified by xiaoku;

授予会话权限：grant create session to xiaoku;

授予创建表的权限：grant create table to xiaoku;

授予表空间的权限：grant unlimited tablespaceto xiaoku;

在http://localhost:5560/isqlplus/login.uix 用户名scott默认密码tiger,默认是关闭的，需要以下进行开启。

SQL> conn / as sysdba
SQL> alter user SCOTT account unlock identified by tiger;
User altered.
SQL> select username,account_status from dba_users where username='SCOTT';
USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT                                OPEN
SQL> conn scott/tiger
Connected.
SQL> select * from tab;
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
DEPT                             TABLE
EMP                               TABLE
BONUS                          TABLE
SALGRADE                   TABLE

 

开启完毕之后，在http://localhost:5560/isqlplus/login.uix输入scott，密码tiger即可登陆，输入刚创建的xiaoku，密码xiaoku也可登陆。