Re: Permission funkiness

Owners of procedures must be granted access to a table directly in order to function under oracle, not through roles. Can't say why it worked under NT. As user a

grant all on foo to b;

Procedure in B's schema should work fine.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Greg Weston" <gwestonREMOVE_at_CAPShome.com> wrote in message
news:150520001233439452%gwestonREMOVE_at_CAPShome.com...


> 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