创建用户:CREATE USER master
IDENTIFIED BY master
DEFAULT TABLESPACE master_space //可选
TEMPORARY TABLESPACE master_temps
PROFILE master_profile //可选,缺省为default
PASSWORD EXPIRE //可选,每次登录后都必须修改口令
ACCOUNT LOCK | UNLOCK; //可选,账号是否锁定
解锁用户:ALTER USER scott ACCOUNT UNLOCK;
查看用户:SELECT username FROM dba_users;
删除用户:DROP USER scott [CASCADE];
修改密码:PASSWORD scott
ALTER USER scott IDENTIFIED BY tiger;
GRANT CONNECT TO scott IDENTIFIED BY tiger;
修改默认表空间:ALTER USER scott DEFAULT TABLESPACE space;
修改临时表空间:ALTER USER scott TEMPORARY TABLESPACE space;
修改表空间配额:ALTER USER scott QUOTA size ON SYSTEM;
获取会话信息:select sid,serial# from session; //logon_time 登录时间,machine 登录所用计算机
终止会话: alter system kill session ‘sid,serial#’;
获取用户执行过的命令:select sid,sql_text,user_name from v$open_cursor;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30077753/viewspace-1409880/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30077753/viewspace-1409880/