程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> OraceleTimesten連接DSN創建用戶

OraceleTimesten連接DSN創建用戶

編輯:Oracle教程

OraceleTimesten連接DSN創建用戶


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)

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved