Re: Create user with dba role - no schema object in that user's name

My answer in Comp.Database.Oracle.Server - please use only one newsgroup /Hans

Hugo Bouckaert wrote:

> Hi
>
> I am new to Oracle but something is puzzling me: in Oracle 9i I created an
> ordinary user with role "connect" and system privileges to create a session,
> create a table and select any dictionary. I also gave that user a default
> tablespace to use and a quota on that and some other tablespaces.
>
> When I create a table in that user's name, in the Oracle 9i Enterprise
> Manager, the user name is listed under Schema and under that schema name for
> that user I can find a heading "tables" and the table that user created.
> This all seems very logical.
>
> Subsequently I decided to create another user with dba privileges (role
> "dba"). This user does NOT appear as an object in the Schema, and one of the
> tables I created with this user ended up in the Schema user name SYS
> although the default tablespace for that new users was set to tablespace
> USERS. I had a look at the new user's object privileges as there was
> something in there about execute on sys.sys_group - perhaps this came in by
> default when I assigned role "dba" to that user. I have taken this privilege
> away but still no schema object is created in that user's name.
>
> Would someone be able to explain under what circumstances a Schema object
> appears / does not appear in a user's name in the Oracle 9i Enterprise
> Manager, how I can restore "execute on sys.sys_group" for the dba users and
> precisely what that means and whether it is necessary for this user to have
> dba privileges?
>
> Thanks very much.
>
> Hugo
Received on Tue Jun 17 2003 - 23:13:49 CDT