Oracle惯用SQL命令[转载]

--创建用户CREATE USER "APITEST"  PROFILE "DEFAULT"     IDENTIFIED BY "apitest" DEFAULT TABLESPACE "LOUSHANG"     TEMPORARY TABLESPACE "TEMP"     ACCOUNT UNLOCK;--为用户指定表空间GRANT UNLIMITED TABLESPACE TO "APITEST";--为用户授权GRANT "CONNECT" TO "APITEST";GRANT "DBA" TO "APITEST";GRANT "RESOURCE" TO "APITEST";--将锁定用户解锁alter user <用户名> account unlock;--修改用户密码alter user <用户名> identified by <新密码>;--删除用户drop user  apitest； ----仅仅是删除用户，drop user apitest cascade ；----会删除此用户名下的所有表和视图。---查看当前用户信息select * from user_users;---查询当前数据库实例中有哪些用户select * from dba_users order by username;---查看当前用户拥有的角色select * from user_role_privs;---查看当前用户所拥有的表select * from user_tables;---查看当前用户所拥有表的列select * from USER_TAB_COLUMNS ;---显示特权用户（一般包括sys、system）select * from v$pwfile_users;---查询当前用户所拥有的所有对象（表、视图、索引、存储函数和过程等）select * from user_objects ----查看序列号select * from user_sequences;---查看当前用户所有的视图select * from  user_views;--查看当前连接信息select SID,SERIAL#,USERNAME,MACHINE,LOGON_TIME from v$session where username='APITEST';--断开指定连接alter system kill session '530,49177';