Re: Sysdba can't create tables?

From: mcstock <mcstock_at_enquery.com>
Date: Tue, 28 Oct 2003 14:58:12 -0500
Message-ID: <PeCdnQdJ2PfrVwOiRVn-tw@comcast.com>

SYSDBA privileges are only activated when the user connects with the 'AS SYSDBA' keywords -- which actually connects the user as 'SYS' (I'm not sure if this has been tightened up yet in 9i)

Best practice: create a role that has the common set of privileges for a particular class of user (i.e. developer, appl_reports, etc.), then grant the role to the end user

example:

create role developer;
grant create table, create procedure, create trigger, create view, create session, alter session ... to developer; grant developer to a_developer_account;

-- 
----------------------------------------
Mark C. Stock
www.enquery.com
(888) 512-2048

"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 Tue Oct 28 2003 - 13:58:12 CST