Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 22nd, 2005, 01:38 PM
Registered User
 
Join Date: Aug 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default what's the difference?

i am new beginner.i don't know the difference between sys account and system account,and when i use sqlplus,i can't log on as sys account,but i can log on as system account. i am so obsessed with it.please help me!!!i will really appreciate it.

 
Old September 23rd, 2005, 02:02 AM
Authorized User
 
Join Date: Aug 2005
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
  Sys is the Internal user name and also have the interanl functions ,procedures and Tables.These database objects are used for tuning and monitoring the databases.
  This user have rights mount and dismount and all rights.This user anutomatically loaded without giving the Service name.

 But system is a default user .

Both of them is the DBA rights. Then only you login the System not in sys.
Thanks.

Regards
Adalarasu.S
xyka Software Ltd.,
Bangalore.





 
Old September 23rd, 2005, 03:57 AM
Registered User
 
Join Date: Aug 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Adalarasu.S, thank you!!!!

 
Old October 8th, 2005, 12:33 PM
Registered User
 
Join Date: Oct 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

if you want to log on as sys account type this at sql prompt
connect sys/password as sysdba
then you will be able to log into sys account, although the sys and system account look quite similar, there are various differnces in them as some of them are mentioned by arasu, usually the system account is dropped and some other account is created for dba, while sys account cannot be dropped and is mostly used to for administration purposes...

Regards
M





Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between name(*) and name() vikkiefd XSLT 3 March 11th, 2008 06:40 AM
Difference ashu .NET Framework 1.x 1 March 27th, 2007 09:46 AM
Difference between / vs ./ vs ../ arulkumar ASP.NET 2.0 Basics 1 February 21st, 2007 12:19 PM
difference Magen Classic ASP Basics 2 January 29th, 2007 04:48 PM
The difference mhergenrader J2EE 1 July 15th, 2005 07:20 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.