Oracle 用户与权限管理
备注点:
备注1.
1 传递系统权限
grant connect to username with admin option;
2.传递实体权限
grant select to username with grant option;
3 授权给全部用户
grant all on product to public;
4.注意点
创建用户先分配create session 登录权限
备注2:
1.使用profile管理用户
①登陆次数限制并锁定
sql>create profile mylockfile limit failed_login_attempts 3
password_lock_time 2;
sql>alter user username profile mylockfile;
②每隔一年修改一次密码宽限3天
sql>create profile myprofile limit password_life_time 365
password_grace_time 3;
sql>alter user username profile myprofile