Home » RDBMS Server » Server Administration » Create DATABASE without being OS Administrator
Create DATABASE without being OS Administrator [message #191333] Tue, 05 September 2006 15:04 Go to next message
gonzametal
Messages: 1
Registered: September 2006
Junior Member
Hello, I have Oracle 9i running on Windows Server 2003. I am a Windows administrator, and want to create an operating system role (user or group) that allow this user or group to create databases without being member of the windows administrators group.

Can a user create a database in server, using the database configuration asistant fron another computer?

Thanks

Gonzalo

Report message to a moderator

Re: Create DATABASE without being OS Administrator [message #191334 is a reply to message #191333] Tue, 05 September 2006 15:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What does the Windows Installation Guide found at http://tahiti.oracle.com have to say on the subject?

Report message to a moderator

Re: Create DATABASE without being OS Administrator [message #191682 is a reply to message #191333] Thu, 07 September 2006 13:55 Go to previous message
rkl1
Messages: 97
Registered: June 2005
Member
Under the window environment, when you install the oracle, it creates a group called ORA_DBA. You can run the lusrmgr.msc from the command or run to see the groups.

Please give a try to create the user and put him inside the ORA_DBA group. As far my understanding, that person could connect as sysdba to database without a password and then use the database configuration assistant to create a new database.

Good Luck.

Report message to a moderator

Previous Topic: ORA-01653 unable to extend table error
Next Topic: Upgrade 8i to 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:54:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.