Default user permissions
- From: "Leo Drobnis" <Leo.Drobnis@xxxxxxxxxxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Nov 2011 10:44:28 -0500
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???
--
//www.freelists.org/webpage/oracle-l
Other related posts:
