提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
前言
用于权限属主错误的情况
使用步骤
用SYSTEM连接TEST数据库 ksql -USYSTEM -p54321 TEST
进行语句拼接,修改模式名
1.修改表所属用户
select ‘alter table PUBLIC.’||c.relname||’ owner to JAVAOATEST;’ from sys_catalog.sys_class c left join sys_catalog.sys_namespace n on n.oid =c.relnamespace where c.relkind=‘r’ and n.nspname=‘PUBLIC’ and c.relname not in(‘pathman_config_params’,‘pathman_config’);
2.修改索引所属用户
select ‘alter index PUBLIC.’||c.relname||’ owner to JAVAOATEST;’ from sys_catalog.sys_class c left join sys_catalog.sys_namespace n on n.oid =c.relnamespace where c.relkind=‘i’ and n.nspname=‘PUBLIC’;
3.修改序列所属用户
select ‘alter sequence PUBLIC.’||c.relname||’ owner to JAVAOATEST;’ from sys_catalog.sys_class c left join sys_catalog.sys_namespace n on n.oid =c.relnamespace where c.relkind=‘S’ and n.nspname=‘PUBLIC’;
4.修改视图所属用户
select ‘alter view PUBLIC.’||c.relname||’ owner to JAVAOATEST;’ from sys_catalog.sys_class c left join sys_catalog.sys_namespace n on n.oid =c.relnamespace where c.relkind=‘v’ and n.nspname=‘PUBLIC’ and c.relname not in(‘pathman_partition_list’,‘pathman_cache_stats’,‘pathman_concurrent_part_tasks’);
5.修改函数和存储过程
函数 alter FUNCTION getChildLst owner to JAVAOATEST;
函数 alter FUNCTION GetHandlingUser owner to JAVAOATEST;
函数 alter FUNCTION GetHandlingUserAndDept owner to JAVAOATEST;
函数 alter FUNCTION GetHandlingUserInfo owner to JAVAOATEST;
6.将拼接的语句保存并依次执行