Re: OPS$ Help

From: Tom Cooke <tom_at_tomcooke.demon.co.uk>
Date: 1996/02/06
Message-ID: <2wzSxJA7N8FxEwwd_at_tomcooke.demon.co.uk>#1/1


In article <4f4p3s$gmo_at_lyra.csx.cam.ac.uk>, Charles Jardine <cj10_at_cam.ac.uk> writes
>pallison_at_ppg.com wrote:
>>I just did a user export from one instance and imported into another.
>>The user ID is SFA and is identified externally.
>>When I go into the new instance and try to select or even describe
>>the tables, I get a table does not exist error. I am logged onto unix
>>as SFA and OPS$SFA shows up in the v$session when I am on.
>>SFA is the owner of the tables.
>>
>>Does anyone know why OPS$SFA can't see the table.
>>
>>In the old instance it can.
>
>Check the values of the INIT.ORA parameter OS_AUTHENT_PREFIX for
>the two instances. I expect the old instance has is set to the
>empty string (spelt ""), and the new instance has it defaulting to
>OPS$.
>
Could it be more obvious than this? You have to export the table with grants, and import them. If you didn't have OS_AUTHENT_PREFIX set, OPS$<thing> wouldn't be able to log in at all.

-- 
Tom Cooke
Received on Tue Feb 06 1996 - 00:00:00 CET

Original text of this message