Xref: alice comp.databases.oracle.server:56414
Path: alice!news-feed.fnsi.net!netnews.com!news.maxwell.syr.edu!tank.news.pipex.net!pipex!uunet!ams.uu.net!ffx.uu.net!ffx2nh3!not-for-mail
From: tmgn <tmgn@excite.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Lost privileges on import
Date: Wed, 07 Jul 1999 17:14:10 -0400
Organization: UUNET
Lines: 47
Message-ID: <3783C322.AB20C177@excite.com>
References: <7lthes$mi4$1@msunews.cl.msu.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: ffx2nh3.news.uu.net 931382048 24587 205.229.27.223 (7 Jul 1999 21:14:08 GMT)
X-Complaints-To: news@ffx2nh3.news.uu.net
NNTP-Posting-Date: 7 Jul 1999 21:14:08 GMT
To: Chris Weiss <weisschr@pilot.msu.edu>
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en


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