Oracle Database Discussions

Hi,

I get the error ORA-01929: no privileges to GRANT when i try to give privilegies on my objects to another user.

Example:

Select about object:

SQL> select o.owner, o.object_name, o.object_type
  2  from all_objects o
  3  where o.object_name = 'SCCPATUALIZADADOS';
 
OWNER                          OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------------------ ------------------
PUBLIC                         SCCPATUALIZADADOS              SYNONYM
FINPAC                         SCCPATUALIZADADOS              PROCEDURE

See, the object owner is FINPAC.

Grant executed by FINPAC user

grant all on SCCPATUALIZADADOS to sdbanco
             *
ERRO na linha 1:
ORA-01929: no privileges to GRANT

My doubt, if i'm the object owner, why don't i get perform the grant statement?


Regards,

Fabrício Pinto