create or replace trigger create_trigger
BEFORE create ON database
declare
v_host varchar2(4000);
begin
v_host:=SYS_CONTEXT('USERENV', 'HOST');
if
v_host like 'WORKGROUP\TERMINAL-SERVER' and ora_dict_obj_type='TABLE' and ora_dict_obj_owner='DW001'
then
Raise_application_error(-20001, 'You have no privilege to do these operations! Please call on DBA !');
end if;
end;
/
限制某些用户创建表的权限的trigger
最新推荐文章于 2022-09-27 11:23:34 发布