【内存数据库】OracleTimesten连接DSN创建用户

************************************************************************ ****原文： blog.csdn.net/clark_xu 徐长亮的专栏 ************************************************************************ 1. 启动开启 [tt@host2 info]$ ttDaemonAdmin -st

1.       启动开启

[tt@host2 info]$ ttdaemonadmin -start -force

/home/tt/TimesTen/tt1122/info/timestend.pid file exists, attempt start due to -force option.

TimesTen Daemon startup OK.

2.       添加测试使用DSN: test_1122

Vi Info/sys.odbc.ini

test_1122=TimesTen 11.2.2 Driver

[test_1122]

Driver=/home/tt/TimesTen/tt1122/lib/libtten.so

DataStore=/home/tt/TimesTen/tt1122/info/DemoDataStore/test_1122

PermSize=40

TempSize=32

PLSQL=1

DatabaseCharacterSet=US7ASCII

3.       连接test_1122

[tt@host2 info]$ ttIsql test_1122

citySHOP多用户商城系统

citySHOP是一款集CMS、网店、商品、分类信息、论坛等为一体的城市多用户商城系统，已完美整合目前流行的Discuz! 6.0论坛，采用最新的5.0版PHP+MYSQL技术。面向对象的数据库连接机制，缓存及80%静态化处理，使它能最大程度减轻服务器负担，为您节约建设成本。多级店铺区分及联盟商户地图标注，实体店与虚拟完美结合。个性化的店铺系统，会员后台一体化管理。后台登陆初始网站密匙：LOVES

0

查看详情

Copyright (c) 1996, 2014, Oracle and/or its affiliates. All rights reserved.

Type ? or "help" for help, type "exit" to quit ttIsql.

4.       创建用户

Command> create user scott identified by tiger;

User created.

Command> grant create table to scott;

Command> grant connect to scott;

Command> grant create view to scott;

Command> grant dba to scott;

15111: Invalid privilege: DBA.  Roles are not supported.

The command failed.

5.       给cache group管理权限

Command> grant create session,admin,cache_manager to scott;

15140: GRANT failed: User SCOTT already has system privilege CREATE SESSION

The command failed.

Command> grant admin,cache_manager to scott;

connect "DSN=test_1122";

Connection successful: DSN=test_1122;UID=tt;DataStore=/home/tt/TimesTen/tt1122/info/DemoDataStore/test_1122;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;DRIVER=/home/tt/TimesTen/tt1122/lib/libtten.so;PermSize=40;TempSize=32;TypeMode=0;

(Default setting AutoCommit=1)