From: "Eric Givler" Newsgroups: comp.databases.oracle.misc References: <39b7e063.862112578@news.alt.net> <39B8F582.9CC50D33@edcmail.cr.usgs.gov> Subject: Re: Is the owner of a table the schema? Lines: 13 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 Message-ID: Date: Sat, 09 Sep 2000 17:09:45 GMT NNTP-Posting-Host: 63.254.26.2 X-Complaints-To: abuse@flash.net X-Trace: news.flash.net 968519385 63.254.26.2 (Sat, 09 Sep 2000 12:09:45 CDT) NNTP-Posting-Date: Sat, 09 Sep 2000 12:09:45 CDT Organization: FlashNet Communications, http://www.flash.net > This is not correct. There are only two cases where an object privilege > can be granted. An object privilege can be granted by the owner of the > object or to anyone who has been granted the object privilege with the > ADMIN option. For proof, see the example below with two users (test1 & > test2): Oh, I believe what you are saying, but can you run your script again with the "grant any table" privilege? I think I confused this with the ability to grant any system privilege (grant any privilege).