第三天3-2各种参数，视图】【profile】【角色失效】

select * from dba_data_files

select * from database_properties

select * from dba_users 

select * from dba_sys_privs where grantee='TEST2'

select * from dba_role_privs where grantee='TEST1'

select * from system_privilege_map 

select * from dba_ts_quotas

select * from session_privs

select * from dba_roles

revoke create table from test1;

create role role_test;

grant create session,create table,resource,dba to role_test;

grant role_test to test1;

alter user test1 default role none;--角色失效，实际上是改变

                                   --select * from dba_role_privs where grantee='TEST1' 中的DEFAULT_ROLE值

GRANTEE                        GRANTED_ROLE                   ADMN_OPTION DEFAULT_ROLE

------------------------------ ------------------------------ --- ---

TEST1                          ROLE_TEST                      NO  NO

select * from session_privs;

alter user test1 default role role_test; --角色生效，实际上是改变

alter role role_test identified by role_test;--防止有人把role 设为none

alter user test1 default role none;

set role none;--把当前session,的角色失效

set role role_test identified by role_test;--当前session的角色生效，当角色有密码时必须加上密码

select * from dba_users --profile与用户关联来设定环境变量，linux系统中就是这个原理

alter user test1 profile profile_test;--修改用户关联的profile文件,虽然已经关联了，但是还没有生效，生效需要再修改一个参数

select profile from dba_users where username='TEST1'

SQL> show parameter limit

NAME                                 TYPE        VALUE

------------------------------------ ----------- ---------

asm_power_limit                      integer     1

java_soft_sessionspace_limit         integer     0

resource_limit                       boolean     FALSE --该参数为true时，alter user test1 profile profile_test;才会生效

alter system set resource_limit=true;

SQL> select sysdate from dual;

select sysdate from dual

*

第 1 行出现错误: --我关联的profile中设置超过1分钟自动断开连接

ORA-02396: 超出最大空闲时间, 请重新连接

C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN 下有很多写好的脚本，scott.sql，utlpwdmg.sql--开启标准化校验

SQL> show user

USER 为 "SYS"

SQL> @ C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlpwdmg.sql

函数已创建。

配置文件已更改 

SQL> alter user test1 identified by test1;

alter user test1 identified by test1

*

第 1 行出现错误:

ORA-28003: 指定口令的口令验证失败

ORA-20001: Password same as or similar to user

alter user test1 identified by "test1" --加双引号密码放什么特殊字符都可以