"Memory Database" Oracletimesten Connection DSN Create user

************************************************************************* * * * 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