用户、权限及角色管理

一 用户管理

1 创建用户语法结构

create_user::=

2 创建用户

1）以管理员身份登录

[oracle@strong ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 1 12:06:59 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

SQL> conn / as sysdba

Connected.

2）创建stu用户

SQL> create user stu

2 identified by oracle

3 default tablespace users

4 temporary tablespace temp

5 quota 5M on users

6 password expire;

User created.

3）给用户授connect权限

SQL> grant connect to stu;

Grant succeeded.

4）使用新用户stu登录数据库

[oracle@strong ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 1 12:11:12 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

SQL> conn stu/oracle@orcl

ERROR:

ORA-28001: the password has expired

Changing password for stu

New password:

Retype new password:

Password changed

Connected.