Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Switch External to Password
Joe,
If I'm not mistaken, I think the account ORC needs create session privileges which you can grant by logging in as internal and executing the command grant create session to ORC;
hth
mkb
In article <%pR24.1206$8P1.61857_at_news1-hme0>, "Joe" <Dont_at_Send.Com>
wrote:
> Hi I'm using 7.3 on NT and most of the tables belonge to ORC
> The ORC account is setup as an "External" account and it can not
> "Create
> Session"
> I need to create new Views and things in the ORC schema I also
> have to grant
> rights on these objects to others.
> I can't connect via the ORC external account using "Plus33w.exe /"
> Or do I change the ORC account to a "password account" log in as
> ORC do my
> work, then after I've finished, Change the account back to an
> "External
> account".
> Thanks
> Joe