Re: Minimum privileges for users

From: Shakespeare <>
Date: Tue, 17 Nov 2009 12:22:40 +0100
Message-ID: <4b028786$0$22938$>

Á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.

Shakespeare Received on Tue Nov 17 2009 - 05:22:40 CST

Original text of this message