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

最新推荐文章于 2025-06-11 14:06:25 发布

lk_db

最新推荐文章于 2025-06-11 14:06:25 发布

阅读量9.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： DB2

本文链接：https://blog.youkuaiyun.com/lk_db/article/details/50963087

DB2 专栏收录该内容

26 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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