Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP: is this expected behaviour?
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:h30ejus00te1u0sfgqqbdf8o86bnm7otjm_at_4ax.com...
> On Thu, 18 Jul 2002 13:12:46 -0400, "Chuck" <chuckh_at_softhome.net>
> wrote:
>
> >Oracle 8.1.7.2
> >
> >I just noticed that a full export of a database does not contain any
grants
> >on SYS's objects. Is this expected/documented behavior (I haven't found
it
> >documented in any manual)? I know that a full export/import does not
import
> >SYS objects but is it supposed to ignore the grants on those objects too?
I
> >have numerous databases where users need EXECUTE and SELECT privileges on
> >some of SYS's objects. If I were to restore those databases from a full
> >export they would be screwed up. Is there an option to force the grants
to
> >be exported, or some other workaround apart from having to export them
> >manually?
> >
>
> On 8i you can avoid direct grants from SYS by creating the appropiate
> procedures with authid invoker
>
What about views that reference SYS views? After importing I also end up with views that fail to compile because they reference SYS views. Received on Thu Jul 18 2002 - 13:25:25 CDT