Re: Minimum privileges for users

From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com.invalid>
Date: Tue, 17 Nov 2009 13:32:24 +0100
Message-ID: <hdu54q$m7c$1_at_news.eternal-september.org>

Shakespeare escribió:

> Álvaro G. Vicario schreef:

>> We have just installed Oracle Database 11g Release 11.1.0.7.0 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 :-?

-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

Received on Tue Nov 17 2009 - 06:32:24 CST