Re: Sysdba can't create tables?

From: mommy dba <mommydba_at_netscape.com>
Date: Tue, 28 Oct 2003 13:52:51 -0600
Message-ID: <vpti4phn6batc6@corp.supernews.com>

SYSDBA is the maintenance privilege, nothing more. You must grant create table or resource for "x" to be able to create a table.....

Dave wrote:

> 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 Tue Oct 28 2003 - 13:52:51 CST