Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    54

    Question Unanswered: Creating a SYSDBA user

    We have a production database Oracle 8.1.7 the is running on AIX 4.3.3. This database was setup using a series of scripts by application provider. Apparently they do not use the SYSADMIN or SYSDBA functions of Oracle, so as far as I can tell these users do not exist. All management of tablespaces/indexes is done through using the admin password for that schema (i.e. sys/syswpd). How would I go about creating a SYSADMIN and SYSDBA user, and/or verifying that these users do not exist. I'm attempting to install Quest Spotlight on Oracle and this tool needs some type of SYSDBA level privileges.

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Check the docs on admin authentication.

    http://download-west.oracle.com/docs...1/dba.htm#1064

Posting Permissions

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