Oracele TimesTen connects to DSN to create a user

Tag: TT TimesTen

1. Enable startup

[[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 the test 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. Connect to test_1122

[[Email protected] info] $ ttisql test_1122

 

Copyright (c) 1996,201 4, 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 are not supported.

The command failed.

5. Manage the permissions of 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)

Oracele TimesTen connects to DSN to create a user