Permission funkiness

From: Greg Weston <gwestonREMOVE_at_CAPShome.com>
Date: 2000/05/15
Message-ID: <150520001233439452%gwestonREMOVE@CAPShome.com>#1/1

Situation:
User A has a table FOO for which a public synonym FOO exists. User B has the DBA role as well as several permissions granted directly to the user. User B does not have any explicit grants on A.FOO. User B has a procedure that references A.FOO. This works under NT4. We do a full export and then import into a freshly- and comparably-created DB on AIX and get "PLS-00201: identifier 'A.FOO' must be declared."

A similar operation (same proc/table, different DBs) a week ago worked fine. Obviously there's a difference somewhere, but I can't see any obvious discrepancies among the various user Bs. Any thoughts? Suggestions for likely candidates of causes welcome at "gweston at cocci dot com".

Thanks.

Greg Received on Mon May 15 2000 - 00:00:00 CDT