OraceleTimesten connects to DSN to create a user

OraceleTimesten connects to DSN to create a user

1. Enable startup

[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. 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

[Tt @ host2 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)