Results 1 to 6 of 6

Thread: Comparison between SYSDBA and SYSOPER

  1. #1
    Join Date
    Nov 2009
    Posts
    39

    Comparison between SYSDBA and SYSOPER

    Hi guys !
    I am a new guy for oracle database and I need some help to all. What is the procedure to connect with database through SQL*plus.Due to installation I got two user which require some password to enter. I had given an appropriate password to both users but I am not getting.What are the existence of both user.I will wait for your reply..Thanks

  2. #2
    Join Date
    Apr 2008
    Posts
    1,949

    Comparison between SYSDBA and SYSOPER

    The SYSDBA and SYSOPER:

    The SYSDBA and SYSOPER both are the users of database. These both user are performing the task of handling the database. During the installation of oracle, I ask to you for password for both user Otherwise you can't continue ahead. Both user belongs to the category of high level users and has different privileges to handle the database activities.

  3. #3
    Join Date
    May 2008
    Posts
    2,015

    Role of SYSDBA in oracle database

    Role and functioning of SYSDBA :

    The SYSDBA user is created when oracle is being installed. It has higher privilege to manage the database.The user of this account can perform all the administrative task.The whole utilities to control the database like tables and views and different data dictionaries are stored in the SYS schema.

    This user can perform so many task to manage the database like :
    1. Designing of the database
    2. Creation of database
    3. Implementation of database
    4. Performing Backup of database
    5. Performing Recovery Operation
    6. Tuning the transaction of database and etc.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,010

    Role of SYSOPER in oracle database

    Role of SYSOPER in database :

    This account is allowed to perform all the administrative task for database but some operation and privilege that is not assigned to this account.This account can perform all administrative task except some mentioned here -

    1. This schema can't perform backup
    2 It is not allowed to perform recovery operation
    3. It is not allowed to upgrade the database.

    NOTE: In both accounts,you can't change the contents of data dictionary.You have unlimited privilege on data dictionary when you would be connected as a sysdba user but can't modify anything in data dictionary.

  5. #5
    Join Date
    May 2008
    Posts
    2,302

    Connecting to database using SQL*plus

    Connecting to database using SQL*plus:

    You can use SQL*Plus tool to connect with oracle database after using SQL language.

    If you are working as a normal user and need to connect with the database,then you can access only default database that has created during installation of oracle database.If you are working in windows environment and need to connect with database then you should have a user name and password of a normal user of database.

    Follow the instructions to connect with database :
    1. Go to the Start menu and click
    2. Move to program menu, and select Oracle.
    3. Choose Ora92 and a list would be appeared from Ora92 directory.
    4. Click on Application development and choose SQL*plus
    5. Enter the User name and password and access whatever you want from database depends on your privileges.

  6. #6
    Join Date
    Aug 2011
    Posts
    1

    Re: Role of SYSDBA in oracle database

    Quote Originally Posted by Katty View Post
    Role and functioning of SYSDBA :

    The SYSDBA user is created when oracle is being installed. It has higher privilege to manage the database.The user of this account can perform all the administrative task.The whole utilities to control the database like tables and views and different data dictionaries are stored in the SYS schema.

    This user can perform so many task to manage the database like :
    1. Designing of the database
    2. Creation of database
    3. Implementation of database
    4. Performing Backup of database
    5. Performing Recovery Operation
    6. Tuning the transaction of database and etc.

    Hi Katty

    Who told you that sysdba is a user? sysdba and sysoper are system privilege

Similar Threads

  1. Replies: 4
    Last Post: 14-03-2012, 04:16 PM
  2. PS3 Drive Comparison HDD or SSD?
    By emMetTi in forum Portable Devices
    Replies: 6
    Last Post: 08-06-2011, 03:52 PM
  3. Photo comparison with N82 and X10
    By Bookmark in forum Portable Devices
    Replies: 6
    Last Post: 08-05-2010, 10:15 PM
  4. Intel 131 and AMD Comparison
    By stephenx in forum Motherboard Processor & RAM
    Replies: 3
    Last Post: 12-01-2010, 04:53 AM
  5. Comparison of web browsers
    By BakshiK in forum Technology & Internet
    Replies: 4
    Last Post: 17-06-2009, 03:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •