isql客户端

参考

连接

isql -d osrdb -P 2003 -U sysdba/szoscar55

参数说明

-d 数据库
-f 执行文件并退出
-h ip
-p 端口
-U 用户名/密码

···

## 库

列出库：list database
删除库: drop database osrdb
创建库：create database osrdb [encoding GBK]


## 用户

创建用户：create user test_usr with password test default tablespace TS_USER_YS_USR_DATA role sysdba;
变更密码：alter user test_usr with password test_change;

## 权限

create role ROLE_ALL_SELECT;
grant select on sys_class to role ROLE_ALL_SELECT;
select grant create on schema  || TABLE_SCHEM ||  to role  ROLE_ALL_SELECT; from (select distinct TABLE_SCHEM from v_sys_tables where  TABLE_SCHEM  not in (INFO_SCHEM,SYSDBA,STAGENT));
select grant select on  || TABLE_NAME ||  to role  ROLE_ALL_SELECT; from (select TABLE_SCHEM|| . ||table_name as table_name from v_sys_tables where  TABLE_SCHEM not in (INFO_SCHEM,SYSDBA,STAGENT));

## 表

查询表定义
select SYS_GET_TABLEDEF from v_sys_table where tablename = 'XXX';