REDO LOG wrote:what happens when you try it?
suppose that we have two users peter and kim
kim has a customers table on his schema, can system grant the select privilege on kim.customers to peter?
thanks for help
You can probably dig around for confirmation if it was in fact 9i R2 that introduced this, but that should really be immaterial at this point in time.
GRANT ANY OBJECT PRIVILEGE: Grant any object privilege that the object owner is permitted to grant. Revoke any object privilege that was granted by the object owner or by some other user with the GRANT ANY OBJECT PRIVILEGE privilege.