I am pretty sure that on Windows, you must have "Administrator" privileges in order to create databases.

I would also check that the drive where the files are being crated has write access for the "DBGroup".

Cheers,

Paul

*********** ORIGINAL MESSAGE ***********

On 30/07/2005 at 11:46 AM Saeed K. Rahimi wrote:

Hello,
We have installed Oracle 10g at our University and running into a problem
with students' access rights. Here is the problem:

We create a NT user group (called DBgroup) and add students in our DBA
class to this group. Then we add the DBgroup to Oracle's DBA group using
the "Administration Assistant for Windows NT". This is to help students
have DBA access to Oracle once they login. When a user of this group logs
in and tries to create a database (using the "database configuration
assistant" GUI tool), we get an error that the user does not have write
access to the drive where the db files are to be created.

We can get around this problem by making the DBgroup a member of NT system
admin. That has the problem of giving students ultimate access to all
resources on the server which we do not want. Is there a way around this?
What are we doing wrong? As mentioned, we use the "database configuration
assistant" to do this. Can this problem be solved using scripts and running
the creation script from SQL PLUS when the user connects as SYSDBA? Is
there anything else that the script should have in addition to "create
database MyDB" leaving everything else as default?

Any help is appreciated.

Regards,
---------------------
Saeed Rahimi
---------------------


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page