ITPub博客

首页 > 数据库 > 数据库开发技术 > Timesten 数据库端需要的配置

Timesten 数据库端需要的配置

原创 数据库开发技术 作者:jolly10 时间:2012-03-27 17:00:06 0 删除 编辑
Timesten 数据库端需要的配置[@more@]

[oracle@qht131 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 23 16:08

Copyright (c) 1982, 2009, Oracle. All rights reserved.


1.建立ttusers表空间
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
With the Partitioning, OLAP, Data Mining and Real Applicati

SQL> create tablespace ttusers datafile 'ttusers.dbf' size

Tablespace created.

2.建立 TIMESTEN schema
SQL> @ initCacheGlobalSchema.sql

Please enter the tablespace where TIMESTEN user is to be created
ttusers
The value chosen for tablespace is ttusers

******* Creation of TIMESTEN schema and TT_CACHE_ADMIN_ROLE starts *******
1. Creating TIMESTEN schema
2. Creating TIMESTEN.TT_GRIDID table
3. Creating TIMESTEN.TT_GRIDINFO table
4. Creating TT_CACHE_ADMIN_ROLE role
5. Granting privileges to TT_CACHE_ADMIN_ROLE
** Creation of TIMESTEN schema and TT_CACHE_ADMIN_ROLE done successfully **

PL/SQL procedure successfully completed.

3.建立cacheadm schema
SQL> create user cacheadm identified by cacheadm
2 default tablespace ttusers
3 quota unlimited on ttusers
4 temporary tablespace temp;

4.赋权限给cacheadm
SQL> @grantCacheAdminPrivileges.sql

Please enter the administrator user id
cacheadm
The value chosen for administrator user id is cacheadm

***************** Initialization for cache admin begins ******************
0. Granting the CREATE SESSION privilege to CACHEADM
1. Granting the TT_CACHE_ADMIN_ROLE to CACHEADM
2. Granting the DBMS_LOCK package privilege to CACHEADM
3. Granting the RESOURCE privilege to CACHEADM
4. Granting the CREATE PROCEDURE privilege to CACHEADM
5. Granting the CREATE ANY TRIGGER privilege to CACHEADM
6. Granting the DBMS_LOB package privilege to CACHEADM
7. Granting the SELECT on SYS.ALL_OBJECTS privilege to CACHEADM
8. Granting the SELECT on SYS.ALL_SYNONYMS privilege to CACHEADM
9. Checking if the cache administrator user has permissions on the default
tablespace
Permission exists
11. Granting the CREATE ANY TYPE privilege to CACHEADM
********* Initialization for cache admin user done successfully *********

5.赋需要cache的表的权限给cacheadm
SQL> grant select on hr.departments to cacheadm;
SQL> grant select, insert, update, delete on hr.employees to cacheadm;
SQL> grant select, insert, update, delete on hr.job_history to cacheadm;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/271283/viewspace-1057740/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-02-20

  • 博文量
    263
  • 访问量
    769044