Re: OPS$ Help
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 CookeReceived on Tue Feb 06 1996 - 00:00:00 CET