**数据库创建连接时**
![](https://box.kancloud.cn/480ef0d964b3c71502b5e3faf08059e3_760x413.png)
密码:seamanLX1
**书本实验环境:**
1. 创建普通用户scott
~~~
create user scott identified by tiger;
~~~
2. 创建书本实验所需要的表
```
SQL> select * from v$version where rownum=1;
BANNER
-------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
SQL> show user
USER is "SYS"
SQL> grant dba to scott;
Grant succeeded.
SQL> alter user scott account unlock;
User altered.
SQL> alter user scott identified by tiger;
User altered.
SQL> conn scott/tiger
Connected.
SQL> create table test as select * from dba_objects;
Table created.
```