From: "Matt Goyer" Newsgroups: comp.databases.oracle References: <3d790e8d$1_2@spamkiller.newsgroups.com> <31354201.0209090545.17879196@posting.google.com> Subject: Re: Privilege Help Date: Mon, 9 Sep 2002 11:34:49 -0400 Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: <3d7cbf66$1_1@spamkiller.newsgroups.com> X-Authenticated-User: mgoyer2 X-Comments: This message was posted through Spamkiller.Newsfeeds.com X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to You may also use our online abuse reporting from: http://www.newsfeeds.com/abuseform.htm X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Organization: Newsfeed.com http://www.newsfeed.com 100,000+ UNCENSORED Newsgroups. > NEVER CREATE OBJECTS AS SYSTEM!!!!!!!!!!!!! I suspected that :). I'm trying to clean up the mess we created.. So is it possible to change the ownership of the tables so that all these tables we erroneously created with system could now be owned by 'em'? Thanks, Matt "Edwin" wrote in message news:31354201.0209090545.17879196@posting.google.com... > Well, you are allowed to select from the table, but you are not able to see it. > as user EM: > a) select * from system.fan; > or > b) Create a synonym private to em or public for everyone and you can > select * from fan; > or > c) alter session set current_schema=SYSTEM; and you can > select * from fan; > > By the way > > NEVER CREATE OBJECTS AS SYSTEM!!!!!!!!!!!!! > > unless you'r oracle