Hi,
I'm sure that student would not be able to create db, because, creating
instance on windows (when you use DBCA or your own scripts) invokes oradim
utility which create windows service i.e. OracleOra92DB. Creating Windows
Service requires Administrative Privileges.

Best Regards
Krystian Zieja / mob

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