创建一个User
create User Student01
indentified By student
Default tableSpace users
tempary TableSpace temp
Quota 3M on User
Quota 5M on temp
--------------------------------
锁定用户
alter user Student01 account lock; --锁定用户,用户便不能登录
alter user Studnet01 account unlock ; --解锁了
--------------------------------
删除用户
Drop User 用户名 cascade
授权: grant all on Student01 to public ;
收权: revoke insert on scott.emp from mike; --从mike用户收回访问scott.emp的表