Default user permissions

From: Leo Drobnis <Leo.Drobnis_at_dealertrack.com>
Date: Tue, 8 Nov 2011 10:44:28 -0500
Message-ID: <C30A2BC684C61749B6FE649A21711DB710E510_at_dtcanexch03.canada.dt.inc>

I am a bit puzzled, maybe I am getting rusty.  

I need to create a user with bare minimum permissions:  

CREATE USER bb_stage

IDENTIFIED BY "password"

DEFAULT TABLESPACE users

TEMPORARY TABLESPACE TEMP; GRANT CONNECT TO bb_stage;

ALTER USER bb_stage QUOTA UNLIMITED ON "USERS";  

Connect role only has create session.

Public has no privileges.  

However the newly created user can create and drop tables.  

I am trying to find where it's coming from.  

Any idea???

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 08 2011 - 09:44:28 CST