Oracle创建用户相关操作

• 查看所有用户：select * from all_users；select * from dba_users
• 创建用户：CREATE USER username IDENTIFIED BY password

• 用户状态共有以下几种   /* 1 = Locked, 2 = Expired, 3 = Locked and Expired, 0 - open */ 1.locked --修改用户的状态为locked or open   alter user username lock account lock(unlock) 2.expired --修改用户状态,使用户的密码过期,状态变为 expired   alter user username password expire 3.locked and expired --修改用户状态   alter user username account lock password expire 4.open

• 为用户授权：GRANT role TO username

授予表空间使用权：grant resource to username

授予创建表权限：grant create table to username

授予连接数据库的权限：grant create session to username