Re: Minimum privileges for users
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 17 Nov 2009 12:22:40 +0100
Message-ID: <4b028786$0$22938$e4fe514c_at_news.xs4all.nl>
Á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 :_(
>
>
Date: Tue, 17 Nov 2009 12:22:40 +0100
Message-ID: <4b028786$0$22938$e4fe514c_at_news.xs4all.nl>
Á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.
Shakespeare Received on Tue Nov 17 2009 - 05:22:40 CST