Xref: alice comp.databases.oracle.server:56423
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!nntp.upenn.edu!msunews!not-for-mail
From: "Chris Weiss" <weisschr@pilot.msu.edu>
Newsgroups: comp.databases.oracle.server
Subject: Re: Lost privileges on import
Date: Wed, 7 Jul 1999 18:09:45 -0400
Organization: Michigan State University
Lines: 73
Message-ID: <7m0j7v$5cd$1@msunews.cl.msu.edu>
References: <7lthes$mi4$1@msunews.cl.msu.edu> <3783C322.AB20C177@excite.com>
X-AUTHid: weisschr
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

Yes, I am exporting and importing with grants, and I have tried different
configurations.  The lost privileges seem to be affect only some schemas and
some users.  It is not consistent between exports.

Chris



tmgn <tmgn@excite.com> wrote in message news:3783C322.AB20C177@excite.com...
>
> Did U Export and import with GRANTS ?
>
> -Thiru
>
> Chris Weiss wrote:
>
> > I have noticed a persistent problem with some roles and privileges being
> > lost on imports.
> >
> > Twice I have had to rebuild or move a database by exporting it,
rebuilding
> > the instance either on the same machine or a new server, and after
import
> > privileges have been lost.  I have created the users with the
appropriate
> > roles and privileges prior to import, and I have ended up dropping roles
and
> > reassigning them back to users in order to re-enable the privileges I
need
> > for those users.  This problem is not universal, nor can I see a pattern
> > other than it happens after an import from a previous Oracle export.  In
> > both cases, the export and import were from the same version of Oracle.
I
> > have tried manipulating a number of features such as service packs, NT
> > services, sequences of import, etc.
> >
> > The problem I have described is more of an annoyance, but I was
wondering if
> > anyone had any insights as to parameter settings for the importer that
might
> > overcome this problem.  I have been using procedures that had never
caused
> > me problems under 7.x.
> >
> > My current platform is 8.0.5 on NT 4.0, Dell Poweredge 6300, 1gb RAM,
7-9Gb
> > 10,000RPM LVD drives with six drives in a Perc array with 16MB cache.
The
> > only other software of any significance is a Seagate back-up program,
but
> > this problem occurred on another server that did not have this software.
> >
> > The lost privileges on import seems to be independent of the NT service
pack
> > level used.  I have run with SP3, SP4, and SP5, and the problem has
appeared
> > with all three service packs.
> >
> > It appears to me like this is simply an Oracle bug with a workaround,
but we
> > have less experienced DBAs on staff who might end up getting confused by
> > these conflicts because they do not manifest themselves as privilege
> > problems directly.
> >
> > Any help would be appreciated, including bug reports.
> >
> > Thanks,
> > Chris Weiss
> > Compuware Corporation
> > Professional Services Division
>