--创建表空间create tablespace qebcp datafile"C:OracleQebCPQebCPqebcp.ora"size 100m reuse default storage(initial 500k next 500k pctincrease 20 );--创建表用户create user qebcp identified by buzhidao default tablespace qebcp quota 10m on users;--分配权限grant connect,resource,dba to qebcp;--查询所有权限select * from DBA_TAB_PRIVS;--查询所授给用户的权限select * from USER_SYS_PRIVS;--显示已授予给用户的所有角色select * from USER_ROLE_PRIVS;Ubuntu下MySQL Server与Client的冲突Oracle 正则表达式相关资讯 oracle
- [INS-32052] Oracle基目录和Oracle (07/22/2014 07:41:41)
- Oracle 4个大对象(lobs)数据类型 (02/03/2013 12:33:05)
- Oracle按时间段分组统计 (07/26/2012 10:36:48)
| - [Oracle] dbms_metadata.get_ddl的 (07/12/2013 07:37:30)
- Liferay Portal 配置使用Oracle和 (07/31/2012 20:07:18)
- Concurrent Request:Inactive (07/20/2012 07:44:05)
|
本文评论 查看全部评论 (0)