`
ice_walf
  • 浏览: 48174 次
  • 性别: Icon_minigender_1
  • 来自: 南京
文章分类
社区版块
存档分类
最新评论

ORA-01031: 权限不足

 
阅读更多

  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;
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics