We've got a customer's database (FB 1.0) where I can't GRANT
table privileges to another user. Though I am the owner of that table
(not SYSDBA).
Shouldn't it be that the owner of a database object may GRANT to
anyone he likes to grant to?

Over the last months/years we had several (well: a few) databases like
that. But in those cases the following script helped.
Unfortunately not in this case (error trying to GRANT to the object's
owner, being connected as the object's owner).


Any idea?

--Heiko

BTW: I also tried to solve this with FB 1.5 - but with no success :-(



CONNECT <database> USER <ObjectsOwner> PASSWORD <password>;

REVOKE ALL ON <object> FROM <ObjectOwner>;

COMMIT;


CONNECT <database> USER 'SYSDBA' PASSWORD <password>;

GRANT ALL ON <object> TO <ObjectOwner> WITH GRANT OPTION;

COMMIT;


CONNECT <database> USER <ObjectOnwer> PASSWORD <password>;

GRANT ALL ON <object> TO <ObjectOwner> WITH GRANT OPTION;

COMMIT;


CONNECT <database> USER 'SYSDBA' PASSWORD <password>;

DELETE FROM RDB$USER_PRIVILEGES WHERE RDB$GRANTOR = 'SYSDBA';

COMMIT;