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

Oracle LazyDBA home page