16.1.1用户账户属性
1.oracle12c中默认带有hr模式；
2.登录hr模式：
#su - oracle
#lsnrctl start
#sqlplus / as sysdba
>startup;
>alter pluggable database all open;
>alter session set container=pdboaec;
>conn hr / hr@pdboaec;
>show user;
3.查看用户的默认表空间
>select default_tablespace from user_users;
4.查看数据库的所有表空间
>col file_name for a60;
>set linesize 160;
>select file_name,tablespacle,bytes from dba_data_files;
5.更换用户的默认表空间
>alter database default tablespace system;
6.查看用户FWQ的默认表空间和默认临时表空间
>create user fwq identified by fwq;
>select username from dba_users; 查看创建的用户FWQ
>select default_tablespace,temporary_tablespace from dba_users whers username='FWQ'; 注意创建的用户名默认为大写；
>alter database default tablespace users; 将数据库默认表空间改为USERS;
>select default_tablespace,temporary_tablespace from dba_users where username='FWQ';
7.修改用户在表空间上的配额
>alter user fwq quota 10m on users; 将用户fwq在USERS表空间上的配额改为10m
>alter user fwq quota unlimited on users; 将用户fwq在USERS表空间的配额改为无限
8.查看用户配额分配情况
>select tablespace_name,bytes,max_bytes from dba_ts_quota where username='FWQ'; "-1"表示无限配额，bytes为0表示他当前未使用两个表空间中的任何一个
>alter user fwq quota 10m on users;
>select tablespace_name,bytes,max_bytes from dba_ts_quota where username='FWQ';
9.查看表空间和临时表空间
>select property_name,property_value from database_properties where property_name like '%TABLESPACE%';
10.修改用户的临时表空间
>alter user fwq temporary tablespace tablespace_name;
11.查看用户账户状态
>select account_status from dba_users;
12.设置用户状态
>alter user fwq account lock;
>alter user fwq account unlock;
>alter user fwq password expire;
16.1.2身份验证方法
16.1.3创建账户
1.创建账户
>create user alois identified by alois
default tablespace users password expire;
>create user afra identified by oracle
default tablespace users quota unlimited on users;
>create user anja identified by oracle;