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

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 - 22:20:36 CDT