SQL> select 'grant all on '||owner||'.'||object_name|| ' to user1;' from dba_objects where object_type='TABLE' and owner='SCOTT';
'GRANTALLON'||OWNER||'.'||OBJE -------------------------------------------------------------------------------- grant all on SCOTT.BONUS to user1; grant all on SCOTT.DEPT to user1; grant all on SCOTT.EMP to user1; grant all on SCOTT.SALGRADE to user1;把以上代码一行行的执行就可以了。
GRANT ALTER ON "JBPM_COMMENT" TO "user" GRANT DELETE ON "JBPM_COMMENT" TO "user" GRANT INDEX ON "JBPM_COMMENT" TO "user" GRANT INSERT ON "JBPM_COMMENT" TO "user" GRANT REFERENCES ON "JBPM_COMMENT" TO "user" GRANT SELECT ON "JBPM_COMMENT" TO "user" GRANT UPDATE ON ""JBPM_COMMENT" TO "user"
'GRANTALLON'||OWNER||'.'||OBJE
--------------------------------------------------------------------------------
grant all on SCOTT.BONUS to user1;
grant all on SCOTT.DEPT to user1;
grant all on SCOTT.EMP to user1;
grant all on SCOTT.SALGRADE to user1;把以上代码一行行的执行就可以了。
ON "JBPM_COMMENT" TO "user"
GRANT DELETE ON "JBPM_COMMENT" TO "user"
GRANT INDEX ON "JBPM_COMMENT" TO "user"
GRANT INSERT ON "JBPM_COMMENT" TO "user"
GRANT REFERENCES ON "JBPM_COMMENT" TO "user"
GRANT SELECT ON "JBPM_COMMENT" TO "user"
GRANT UPDATE ON ""JBPM_COMMENT" TO "user"