Home » SQL & PL/SQL » SQL & PL/SQL » How to make a user with system privelige same as user internal
How to make a user with system privelige same as user internal [message #23653] Sun, 22 December 2002 01:31 Go to next message
Dhiren Patel
Messages: 16
Registered: December 2002
Junior Member
I am usally start a database with command but even i give dba role to user,it won't allow me to start.so iwant to create a user who can start database and shutdown database;

Report message to a moderator

Re: How to make a user with system privelige same as user internal [message #23662 is a reply to message #23653] Mon, 23 December 2002 06:31 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
add the user in the DBA GROUP.
give him the SYSDBA and SYSOPER privs

Report message to a moderator

Previous Topic: Please help me slove the Problem
Next Topic: Error:ORA-03232: unable to allocate an extent of 15 blocks from tablespace 3
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 19:49:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.