Re: Sysdba can't create tables?

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Thu, 30 Oct 2003 00:52:01 +0200
Message-ID: <3fa04492$1_1@news.estpak.ee>

You have to connect "x/pwd as sysdba" in order to use privileges coming from sysdba special privilege.

Tanel.

"Dave" <dave1_nyc_at_hotmail.com> wrote in message news:4e13bd55.0310281144.6d4a99f3_at_posting.google.com...
> I'm sure I'm doing something stupid, but I'd appreciate help with
> this...
>
> I'm running Oracle 921 on Windows. I have a database and am connecting
> with user "sys" as "sysdba". I do the following:
>
> create user x;
>
> grant create session to x;
>
> grant sysdba to x;
>
> All work fine, but x has insufficient privileges to create a table.
> And there's only one Oracle service running on this machine.
>
> Thanks
Received on Wed Oct 29 2003 - 16:52:01 CST