Oracele Timesten连接DSN创建用户

esdghj

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

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)