Re: Minimum privileges for users

From: Álvaro G. Vicario <>
Date: Tue, 17 Nov 2009 13:32:24 +0100
Message-ID: <hdu54q$m7c$>

Shakespeare escribió:
> Álvaro G. Vicario schreef:

>> We have just installed Oracle Database 11g Release in a
>> Windows Server 2003 box. We'll be using it to develop PHP applications
>> with Oracle backend so:
>> 1. We haven't purchased a license
>> 2. There is no DBA in the house
>> With only 10g XE edition background, I'm pretty lost with user
>> administration. (I'm using the built-in web console.) I just need to
>> create users that have full access to their own schemas and no access
>> to system or other user's stuff. I'm currently assigning the "CONNECT"
>> and "RESOURCE" roles and all the system privileges but I suppose
>> that's way too much.
>> What permissions would be appropriate?
>> I understand it's all explained in the extensive documentation but
>> it's just a disposable dev box and I am not a DBA :_(

> None. You need a license.

Gasp.... Is is possible I misread the license terms or confused them with the XE edition :-?

-- - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web:
-- Mi web de humor satinado:
Received on Tue Nov 17 2009 - 06:32:24 CST

Original text of this message