Home » SQL & PL/SQL » SQL & PL/SQL » How can i login as DBA (merged)
How can i login as DBA (merged) [message #316588] Sat, 26 April 2008 00:59 Go to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

Hi

I setup oracle 10g. I logged in as default user: scott password: tiger & like to create new user by this command
CREATE USER user_name
IDENTIFIED BY password;

but i get error like ORA-01031: insufficient privileges


can u tell me how can i give this user sufficient privilege or login as administrator

Thanx in advance
Suman.
Re: How can i login as DBA [message #316591 is a reply to message #316588] Sat, 26 April 2008 01:21 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
user SCOTT doesn't have the DBA right.What password did you give to SYSTEM / SYS during installation?You need to have a DBA rights to create a user.


regards,
Re: How can i login as DBA [message #316593 is a reply to message #316591] Sat, 26 April 2008 01:50 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

thanx for reply. SYSTEM / SYS password: nothing but how can i login as a DBA.

regards,
suman
Re: How can i login as DBA [message #316594 is a reply to message #316593] Sat, 26 April 2008 01:59 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
Nothing??? did you not give password to the SYSTEM/SYS during installation or if someone else has the DBA rigths ask him to create the user for you.


regards,
Re: How can i login as DBA [message #316596 is a reply to message #316594] Sat, 26 April 2008 02:08 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

i gave password & password is : nothing. better u think i gave password but where i to put this password to login as dba

thanks
suman
Re: How can i login as DBA (merged) [message #316597 is a reply to message #316588] Sat, 26 April 2008 02:16 Go to previous messageGo to next message
deepakkrjain
Messages: 4
Registered: April 2007
Location: Delhi
Junior Member

Dear Friend.


Used this user name or password. those are dba user name and passwords.


user id/password: system/manager
sys/change_on_install




regards.
Re: How can i login as DBA [message #316599 is a reply to message #316596] Sat, 26 April 2008 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i gave password & password is : nothing

so use "connect system/nothing"

Regards
Michel
Re: How can i login as DBA (merged) [message #316601 is a reply to message #316597] Sat, 26 April 2008 02:56 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

i got it. thanks friends..

regards,
suman
Re: How can i login as DBA (merged) [message #316613 is a reply to message #316601] Sat, 26 April 2008 09:04 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

hi Michel

from the command promt i did as follows & entered as DBA
Enter user-name: SYS AS SYSDBA
Enter password:


regards
suman
Re: How can i login as DBA (merged) [message #316616 is a reply to message #316613] Sat, 26 April 2008 09:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are not DBA you are SYSDBA
SYSDBA is only for database maintenance purpose (startup, shutdown, recover...).

Regards
Michel
Re: How can i login as DBA (merged) [message #316631 is a reply to message #316616] Sat, 26 April 2008 12:06 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

then to enter as a complete DBA, what i to do??


regards
suman
Re: How can i login as DBA (merged) [message #316632 is a reply to message #316631] Sat, 26 April 2008 12:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sat, 26 April 2008 09:35
Quote:
i gave password & password is : nothing

so use "connect system/nothing"

Regards
Michel


Re: How can i login as DBA (merged) [message #316633 is a reply to message #316588] Sat, 26 April 2008 12:43 Go to previous message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

Thanks
Previous Topic: how to check the package body information
Next Topic: update on inherited column
Goto Forum:
  


Current Time: Sun Dec 04 12:36:08 CST 2016

Total time taken to generate the page: 0.12602 seconds