Who can grant Object Permissions ?

I am supporting a few Oracle servers and trying to understand how Oracle manages object permissions. My experience is with Sybase and the "sa" account is able to grant any permissions.

On Oracle, I login as SYS, but cannot grant permission on a table because I have "insuffitient permission" or something like.

I read through the manuals, and as I understood, only the schema that owns the object can grant permissions. If understood this correctly, how do you grant permissions on objects if you don't have the user's password ( the one that owns the object)

Thank You Received on Wed Mar 20 2002 - 13:22:26 CST