Re: Privilege Help
Date: Mon, 9 Sep 2002 11:34:49 -0400
Message-ID: <3d7cbf66$1_1_at_spamkiller.newsgroups.com>
> 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" <vanmeerendonk_at_wxs.nl> wrote in message
news:31354201.0209090545.17879196_at_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
Received on Mon Sep 09 2002 - 17:34:49 CEST