如果你已经创建好了用户名密码、并且已经有了一个可以调用的table,直接跳到第3部分
1. 创建数据库用户名密码
Create the user
create user TENANT01
identified by “”
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT
password expire;
Grant/Revoke role privileges
grant aq_administrator_role to TENANT01 with admin option;
grant dba to TENANT01 with admin option;
grant mgmt_user to TENANT01;
Grant/Revoke system privileges
grant unlimited tablespace to TENANT01 with admin option;
2. 创建一个table
create table userinfo(
userid varchar(48),
userpassword varchar(48),
crdt date,
cruser varchar(48));
录入信息
insert into userinfo(
userid, userpassword, crdt, cruser)
values(,,sys.date(),created_user);
3. VS里修改App.config
<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />
</startup>
<connectionStrings>