存储过程中drop 其他用户表,权限不足,why
create or replace procedure ppptest(tab_Name in varchar2) is
begin
delete from sde.layers where Upper(table_name)=upper(tab_name);
end ;
Error: PL/SQL: ORA-01031: 权限不足
查看权限,角色如下,
SQL> select * from USER_ROLE_PRIVS;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
DLCC CONNECT NO YES NO
DLCC DBA YES YES NO
SQL>
SQL> select * from user_sys_privs;
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
DLCC CREATE VIEW NO
DLCC CREATE TABLE NO
DLCC DROP ANY VIEW YES
DLCC DROP ANY INDEX YES
DLCC DROP ANY TABLE YES
DLCC CREATE ANY VIEW NO
DLCC CREATE ANY TABLE NO
DLCC UNLIMITED TABLESPACE YES