DB2在操作系统用户下创建数据库schema

最新推荐文章于 2024-04-02 15:45:24 发布

原创最新推荐文章于 2024-04-02 15:45:24 发布 · 9.9k 阅读

1 ·

CC 4.0 BY-SA版权

DB2 专栏收录该内容

26 篇文章

订阅专栏

本文档展示了如何在DB2环境下，作为操作系统用户DB2INST9连接到数据库TEST9，并创建名为aaa的Schema。接着创建表aaa.aaa，进行增删查改操作。还涉及到权限管理，将权限授予aaa用户对db2inst9.t2表的操作，并演示了在aaa Schema下执行查询、插入和删除操作。

[db2inst9@th1 ~]$ db2 connect to test9

Database Connection Information

Database server = DB2/LINUXX8664 9.7.10
SQL authorization ID = DB2INST9
Local database alias = TEST9

db2 => create schema aaa
DB20000I The SQL command completed successfully.
db2 => create table aaa.aaa(id int)
DB20000I The SQL command completed successfully.
db2 => select * from aaa.aaa

ID
-----------

0 record(s) selected.

db2 => drop table aaa.aaa
DB20000I The SQL command completed successfully.
db2 => connect to test9

Database Connection Information

Database server = DB2/LINUXX8664 9.7.10
SQL authorization ID = DB2INST9
Local database alias = TEST9

db2 => grant select,update,insert,delete on db2inst9.t2 to aaa
DB20000I The SQL command completed successfully.
db2 => connect to test9 user aaa
Enter current password for aaa:
SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR
PASSWORD INVALID"). SQLSTATE=08001

db2 => SET CURRENT SCHEMA = aaa
DB20000I The SQL command completed successfully.
db2 => select * from db2inst9.t2

C1 C2
----------- --------------------
1 aa
22 qwer

2 record(s) selected.

db2 => insert into db2inst9.t2 values (1,'qqqq')
DB20000I The SQL command completed successfully.
db2 => delete from db2inst9.t2 where c2='qqqq'
DB20000I The SQL command completed successfully.
db2 => commit
DB20000I The SQL command completed successfully.