Privilege alter table
Hello,
Version oracle 11.2
Centos
I have two schemas the firt schema has role DBA and there is a procedure, it do a update in the second schema , but the first schema can't do the update, and I tried gave it role DBA and other privilege as :
grant alter any table to usuario;
grant update any table to usuario;
grant select any table to usuario8;
--GRANT INSERT ANY TABLE TO usuario;
grant grant all privilege to usuario
But itsn't posible than it work, In version 10g it the procedure work well, these are schemas of test, I only need any privilege with which the first schema can do the UPDATE.
Version oracle 11.2
Centos
I have two schemas the firt schema has role DBA and there is a procedure, it do a update in the second schema , but the first schema can't do the update, and I tried gave it role DBA and other privilege as :
grant alter any table to usuario;
grant update any table to usuario;
grant select any table to usuario8;
--GRANT INSERT ANY TABLE TO usuario;
grant grant all privilege to usuario
But itsn't posible than it work, In version 10g it the procedure work well, these are schemas of test, I only need any privilege with which the first schema can do the UPDATE.
0