Re: user with administrative priviledges

From: <frank.van.bortel_at_gmail.com>
Date: 10 Oct 2006 01:11:31 -0700
Message-ID: <1160467891.403474.153580@b28g2000cwb.googlegroups.com>

fireball schreef:
>
> ps:
> what is a difference between:
> conn user/pwd as sysdba
> and
> conn user/pwd as normal
> assuming, user has DBA role granted.
> ?

The fact that it does not work:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

SQL> create user fireball identified by fireball 2 default tablespace users
3 temporary tablespace temp;
User created.

SQL> grant connect, resource, dba to fireball; Grant succeeded.

SQL> connect fireball/fireball as sysdba ERROR:
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE. SQL> Received on Tue Oct 10 2006 - 03:11:31 CDT