1.
--查询链接的用户
select username,sid,serial#,osuser from v$session ;
--删除链接的用户
alter system kill session '154,349';
2.
--删除用户(TEST)
DROP USER TEST CASCADE ;
3.
--创建用户(TEST)
CREATE USER TEST
ACCOUNT UNLOCK
IDENTIFIED BY test
DEFAULT TABLESPACE USERS;
GRANT IMP_FULL_DATABASE TO TEST;
GRANT RESOURCE TO TEST;
GRANT CONNECT TO TEST;
ALTER USER TEST DEFAULT ROLE ALL;
GRANT CREATE VIEW TO TEST;
GRANT SELECT ON DBA_DATA_FILES TO TEST;
GRANT SELECT ON DBA_FREE_SPACE TO TEST;
GRANT QUERY REWRITE TO TEST;
GRANT CREATE SESSION TO TEST;
GRANT GLOBAL QUERY REWRITE TO TEST;
GRANT CREATE MATERIALIZED VIEW TO TEST;
GRANT UNLIMITED TABLESPACE TO TEST;
GRANT CREATE TRIGGER TO TEST;