Re: granting another users tables ?
From: Tony Rodgers <trodgers>
Date: 1995/05/22
Message-ID: <3pqhjt$5gt_at_tbsnames.turner.com>#1/1
Date: 1995/05/22
Message-ID: <3pqhjt$5gt_at_tbsnames.turner.com>#1/1
I've run into the same situation with doing grants on objects. Apparently, in Oracle, the only way to grant OBJECT privileges is to (1) be the owner of the object (as you said, connect as the owner of the table and then issue the grants. ... or ... (2) Have been previously granted the privileges being granted along with the GRANT option.
This isn't necessary when doing system privilege grants. Received on Mon May 22 1995 - 00:00:00 CEST