-- 生成sql禁用所有約束
SELECT 'ALTER TABLE ' || table_name || ' disable CONSTRAINT ' || constraint_name || ';' FROM user_constraints where CONSTRAINT_TYPE = 'R';
-- 生成sql把已經(jīng)禁止的約束打開
SELECT 'ALTER TABLE ' || table_name || ' enable CONSTRAINT ' || constraint_name || ';' FROM user_constraints where CONSTRAINT_TYPE = 'R';
-- 生成sql刪除所有約束
SELECT 'ALTER TABLE ' || table_name || ' drop CONSTRAINT ' || constraint_name || ';' FROM user_constraints;
-- 生成sql刪除所有對象
select 'drop ' || object_type ||' '||object_name||';' as sqlstatment from user_objects order by sqlstatment;
-- 查看當前用戶權限
select * from session_privs;
-- 查看當前用戶角色
select * from session_roles;
-- 查看當前用戶角色
select * from session_roles;