v_StrSql0 := 'CREATE TABLE T_ROWID NOLOGGING AS
SELECT A.RID FROM (
SELECT T.ROWID AS RID
FROM T_ORG_test T
ORDER BY T.ROWID
) A';
BEGIN
EXECUTE IMMEDIATE v_StrSql0;
ORA-01031: 权限不足
sys用户: grant dba to AAA
sys用户: GRANT EXECUTE ON SYS.Dbms_Crypto TO AAA_local;
执行v_StrSql0用户AAA:grant all privilege to AAA;
SELECT A.RID FROM (
SELECT T.ROWID AS RID
FROM T_ORG_test T
ORDER BY T.ROWID
) A';
BEGIN
EXECUTE IMMEDIATE v_StrSql0;
ORA-01031: 权限不足
sys用户: grant dba to AAA
sys用户: GRANT EXECUTE ON SYS.Dbms_Crypto TO AAA_local;
执行v_StrSql0用户AAA:grant all privilege to AAA;
2017

被折叠的 条评论
为什么被折叠?



