************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************
1. start to open
[Email protected] info]$ Ttdaemonadmin-start-force
/home/tt/timesten/tt1122/info/timestend.pid file exists, attempt start due to-force option.
TimesTen Daemon startup OK.
2. Add test using 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. connecting test_1122
[Email protected] info]$ Ttisql test_1122
Copyright (c) 1996, Oracle and/or its affiliates. All rights reserved.
Type? or ' help ' for help, type ' exit ' to quit Ttisql.
4. Create a user
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 is not supported.
The command failed.
5. managing permissions for the 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)
"Memory Database" Oracletimesten Connection DSN Create user