Re: grants using OEM and SQLPLUS
From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 10 Mar 2004 16:41:50 +0100
Message-ID: <c2nd63$1vet6f$1_at_ID-93924.news.uni-berlin.de>
Date: Wed, 10 Mar 2004 16:41:50 +0100
Message-ID: <c2nd63$1vet6f$1_at_ID-93924.news.uni-berlin.de>
"Steven Fox" <steven.fox_at_dfas.mil> schrieb im Newsbeitrag
news:256a75fa.0403100638.6cd7ccc1_at_posting.google.com...
> When doing a grant to a table using OEM I get an ora-1031 insufficiant
> previlages.... BUT when I try the same grant in SQLPLUS..... No
> problem....
> Any ideas????
( Your Oracle version ? )
Who are You (login) in OEM / in SQLPlus ?
Only the owner of a table can grant object priviliges other users. Even SYSTEM/MANAGER cannot grant SELECT on myOtherSchema.myTable to SomeOtherUser.
hth, Jan
OEE 8.1.7.3
Received on Wed Mar 10 2004 - 16:41:50 CET