- 浏览: 525910 次
- 性别:
- 来自: 广州
文章分类
- 全部博客 (339)
- JavaBase (27)
- J2EE (70)
- Database (22)
- Spring (3)
- struts1.x (6)
- struts2.x (16)
- Hibernate (10)
- IBatis (4)
- DWR (1)
- SSH (5)
- Oracle (31)
- HTML (12)
- javascript (11)
- Thinking (3)
- Workflow (5)
- Live (13)
- Linux (23)
- ExtJS (35)
- flex (10)
- php (3)
- Ant (10)
- ps (1)
- work (2)
- Test (1)
- Regular Expressions (2)
- HTTPServer (2)
- 方言 (1)
- 生活 (2)
- Sybase PowerDesigner (0)
最新评论
-
mikey_5:
非常感谢楼主的分享,<parameter propert ...
Check the output parameters (register output parameters failed) IN Ibatis -
影子_890314:
我现在也有这个错误,求解!
Check the output parameters (register output parameters failed) IN Ibatis -
358135071:
学习了,感谢分享!
使用hibernate 代替 mysql 中 limit 進行分頁 -
wjpiao:
你下面的“正确的映射”里面不是还是有number类型吗?
Check the output parameters (register output parameters failed) IN Ibatis -
zh_s_z:
很有用!弄一份吧!
Oracle数据库分区表操作方法
/*********************************************************************************************************************
1、创建表空间,角色及用户
**********************************************************************************************************************/
/* 以sys 用户登录 */
conn sys/pwd AS SYSDBA;
/* 在sys用户下执行 */
---create tablespace
DROP TABLESPACE tongTabSpace INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE tongTabSpace
LOGGING
DATAFILE 'E:\oracle\product\10.2.0\oradata\orcl\tongTabSpace01.DBF'
SIZE 100M
AUTOEXTEND ON
NEXT 50M MAXSIZE 10240M
EXTENT MANAGEMENT local;
/* 创建用户 */
---并指定表空间
DROP USER admin;
CREATE USER admin IDENTIFIED BY admin
DEFAULT TABLESPACE tongTabSpace TEMPORARY TABLESPACE temp;
---create role
--系统管理员角色
DROP ROLE roleadmin;
CREATE ROLE roleadmin;
--grant privilege
/* 授权系统管理员角色权限 */
REVOKE
--创建会话
CREATE SESSION,
--replace SESSION,
--创建表
CREATE TABLE,
--replace TABLE,
--表空间不受限制--权限大太,无法授予
--UNLIMITED TABLESPACE,
--创建视图
CREATE VIEW,
---replace VIEW,
--创建序列
CREATE SEQUENCE,
--replace SEQUENCE,
--创建存储过程
CREATE PROCEDURE,
--replace PROCEDURE,
--创建触发器
CREATE TRIGGER,
replace TRIGGER,
--创建索引
CREATE INDEXTYPE,
replace INDEXTYPE
FROM roleadmin;
GRANT
--创建会话
CREATE SESSION,
--replace SESSION,
--创建表
CREATE TABLE,
-- replace PROCEDURE,
--表空间不受限制--权限大太,无法授予
--UNLIMITED TABLESPACE,
--创建视图
CREATE VIEW,
-- replace VIEW,
--创建序列
CREATE SEQUENCE,
--replace SEQUENCE,
--创建存储过程
CREATE OR replace PROCEDURE,
replace PROCEDURE,
--创建触发器
CREATE TRIGGER,
replace TRIGGER,
--创建索引
CREATE INDEXTYPE,
replace INDEXTYPE
TO roleadmin;
---表空间不受限制权限单独授予(因为权限大太,无法授予)
GRANT UNLIMITED TABLESPACE TO admin;
/* 将角色权限授予用户 */
REVOKE roleadmin FROM admin;
GRANT roleadmin TO admin;
/*********************************************************************************************************************
2、创建表空间,角色及用户
**********************************************************************************************************************/
/* 以sys 用户登录 */
--conn sys/change_on_install AS SYSDBA;
/* 创建用户 */
---并指定表空间
DROP USER jtosa;
CREATE USER jtosa IDENTIFIED BY dawning
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
---create role
--系统管理员角色
DROP ROLE roleadmin;
CREATE ROLE roleadmin;
--grant privilege
/* 授权系统管理员角色权限 */
REVOKE
--创建会话
CREATE SESSION,
--创建表
CREATE TABLE,
--表空间不受限制--权限大太,无法授予
--UNLIMITED TABLESPACE,
--创建视图
CREATE VIEW,
---replace VIEW,
--创建序列
CREATE SEQUENCE,
--创建存储过程
CREATE PROCEDURE,
--创建触发器
CREATE TRIGGER,
--创建索引
CREATE INDEXTYPE
FROM roleadmin;
GRANT
--创建会话
CREATE SESSION,
--创建表
CREATE TABLE,
--表空间不受限制--权限大太,无法授予
--UNLIMITED TABLESPACE,
--创建视图
CREATE VIEW,
--创建序列
CREATE SEQUENCE,
--replace SEQUENCE,
--创建存储过程
CREATE PROCEDURE,
--创建触发器
CREATE TRIGGER,
--创建索引
CREATE INDEXTYPE
TO roleadmin;
---表空间不受限制权限单独授予(因为权限大太,无法授予)
GRANT UNLIMITED TABLESPACE TO jtosa;
/* 将角色权限授予用户 */
REVOKE roleadmin FROM jtosa;
GRANT roleadmin TO jtosa;
发表评论
-
windows 启动关闭Oracle监听和服务
2012-01-05 10:28 2502经常要用数据库,让他自己启动的话,开机太慢,所以用命 ... -
入浅出Oracle--DBA入门、进阶与诊断案例
2011-01-18 10:14 1080数据仓库工具箱:维度建模的完全指南(第二版) Oracle ... -
oracle 树形查找
2010-12-02 10:33 681主题:Oracle树查询及相关函数 http://www.i ... -
create oracle DB auto increment PK trigger
2010-10-11 12:05 1008DROP SEQUENCE seq_chat_group_Id ... -
like %abc%
2010-09-09 00:23 1317关键字: oracle 优化 象 ... -
oracle user manager
2010-09-08 10:05 1011创建与管理用户账户 ... -
Oracle Execute Immediate
2010-06-24 23:10 975EXECUTE IMMEDIATE 在某些情 ... -
oracle 常用的sql
2010-06-20 09:16 1030... -
oracle parallel execution example
2010-06-09 23:07 1277引子:以前一直没太关 ... -
Oracle Parallel Query
2010-06-09 23:06 2100Oracle Parallel Query(OPQ)可 ... -
oracle parallel computing
2010-06-09 23:01 1946用Oracle并行查询发挥多C ... -
Oracle数据库分区表操作方法
2010-06-09 22:46 1221文章转自: http://xu20cn.blog.51cto. ... -
Oracle并行服务器(OPS) Oracle Parallel Server
2010-06-09 22:44 1024文章转载自: http://xu20cn.blog.51c ... -
一个简单的Oracle任务
2010-05-13 08:36 735http://www.cnblogs.com/tohen/ar ... -
ORACLE DATE FUNCTION 大全
2010-05-13 00:47 1147TO_DATE格式 Day: dd number 12 ... -
ORACLE DB 定时任务机制
2010-05-13 00:45 1301简介 本文首先简单介绍了Oracle 8的数据复制的 ... -
ORACLE日期时间函数大全
2010-05-12 08:52 1184ORACLE日期时间函数大全 ... -
ORACLE时间处理大全
2010-05-12 08:48 1490... -
paging in oracle
2010-04-10 17:41 680/************************* get ... -
Extract use in oralce
2010-04-09 11:53 930racle中Extract函数的用法 SELEC ...
相关推荐
Mongodb3.0createUser说明
Create user <user> identified by Alter user <user> default tablespace Alter user <user> quota <size> on Alter user <user> account lock|unlock Alter user <user> identified by Alter user <user...
sql>create user wwuser identified by wwuser default tablespace wwspace temporary tablespace temp 位置:D:\wwOracle\wwspace.dbf 用户名: wwuser 密码: wwuser 临时表:temp 3、创建角色 ...
Create a worker role project to perform backend processes Store persistent data with Windows Azure Storage Develop a scalable database application in the cloud using Microsoft SQL Azure™ Connect ...
Set up game events to trigger and NPCs, and create a role-playing game Add artificial intelligence to game characters to add some life to game NPCs Create 2D maps and add them to the strategy game ...
在PostgreSQL 里没有区分用户和角色的概念,”CREATE USER” 为 “CREATE ROLE” 的别名,这两个命令几乎是完全相同的,唯一的区别是”CREATE USER” 命令创建的用户默认带有LOGIN属性,而”CREATE ROLE” 命令创建...
Create engaging apps with fragments to provide a rich user interface that dynamically adapts to the individual characteristics of your customers' tablets and smartphones About This Book From an ...
and drillthrough capabilities with cubes •Manage role-based security and restrict data access •Deploy and maintain a database in a production environment CD features •All practice exercises and ...
Create dimensions and measure groups to build, browse, and modify OLAP cubes•Design objects to handle unique financial analysis requirements•Improve query performance with aggregations and user ...
and drillthrough capabilities with cubes •Manage role-based security and restrict data access •Deploy and maintain a database in a production environment CD features •All practice exercises and ...
性能的注意点,无法理清部分...3) 新建 t_user , t_role , t_user_role 表 先不要建立索引和主外键,编写一个存储过程 Create procedure proc_init_sysdata(INT userNum,INT role roleNum),填写一个 spring-dbms-demo1
important role in the development of next generation, easy-to-use and intuitive user interfaces and web content. Some examples of this are shown in Figure 1.1. Over the next few years, you can expect ...
Learn to use exciting new development tools and create applications for Windows 8 If you're a beginning developer, there's no better place to get up to speed on the Windows 8 SDK than this Wrox guide...
loopback-load-user,基于配置的模块,用于自动加载静态用户此模块与回送一起使用,以处理静态用户,角色和... // Create an Admin Role // Create a User named 'some-user' // Map 'some-user' to the Admin Role.
explain the basics of jQuery and show how to create a simple, yet efficient client- server chat mechanism using AJAX. Chapter 9: AJAX Grid explains the usage of an AJAX-enabled data grid plugin, ...
Depending on your role and skill level, this book will serve as a companion to the other Wrox books in the Microsoft SQL Server Beginning and Professional series.. This book will help you to learn: ...
* Design a SharePoint 2010 environment that supports social computing features including user profiles and My Sites * Design and implement search strategy in SharePoint 2010 * Translate business ...
* Design a SharePoint 2010 environment that supports social computing features including user profiles and My Sites * Design and implement search strategy in SharePoint 2010 * Translate business ...
CREATE ROLE app_user IDENTIFIED BY hello; GRANT CREATE VIEW TO app_user; GRANT app_user TO <用户名>; Oracle的预安装角色有: 角 色 权 限 CONNECT 登录数据库 RESOURCE 创建新对象(表、索引) DBA ...