查看所有用户
- select * from all_users;
查看当前用户的权限
- select * from user_sys_privs;
创建用户
- create user u2 identified by u2;
授予用户建立连接和建表权限
- grant create session,
- create table to u2;
连接到 u2
- conn u2/u2
查看账号属性
- select * from user_users;
创建摘要文件 pfile[profile 文件可以用于管理登录参数]
- create profile p2 limit FAILED_LOGIN_ATTEMPTS 3PASSWORD_LOCK_TIME 1;
将 pfile 赋予用户
- alter user u2 profile p2;
验证是否授予成功
- select username,
- profile from dba_users;
检验 p1 效果
- sys@ORCL > conn u2 / 1ERROR: ORA - 01017 : invalid username / password;
- logon denied警告: 您不再连接到ORACLE。sys@ORCL > conn u2 / 2ERROR: ORA - 01017 : invalid username / password;
- logon deniedsys@ORCL > conn u2 / 3ERROR: ORA - 01017 : invalid username / password;
- logon deniedsys@ORCL > conn u2 / 4ERROR: ORA - 28000 : the account is lockedsys@ORCL >
连续输错四次密码, 令账户被锁
sysdba 身份登录查看
- sys@ORCL > conn sys
- /**** as sysdba已连接。sys@ORCL> select username,account_status from dba_users where username='U2';USERNAME ACCOUNT_STATUS-----------------------------------------------------------U2 LOCKED(TIMED)sys@ORCL>*/
账号解锁
- alter user u2 account unlock;
就爱阅读 www.92to.com 网友整理上传, 为您提供最全的知识大全, 期待您的分享,转载请注明出处。
来源: