Insufficient Priviledge Error When....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Insufficient Priviledge Error When....

  1. #1
    Join Date
    Aug 2003
    Posts
    13

    Insufficient Priviledge Error When....

    Scenario: I'm using an Oracle database (8i) running WIN 2000 to practice with... I log on as Scott/Tiger or Sys/Manager and conn / as sysdba to do different exercises in my Element K Book. Connecting as "sysdba" why would I get insufficient priviledges when I try to use the alter command or shutdown the database? For instance, I got that error when I tried to alter the database to start the archive log mode. Also, got it a second time when I tried to shut down the database as mentioned earlier? What would be the best way to resolve this problem? Thanks in advance.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Because your Windows user account is not in the ORA_DBA group.

  3. #3
    Join Date
    Aug 2003
    Posts
    13
    Thanks much. That did it!!!

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Damn!! You know what?! If we DBA's keep getting problems solved this quickly no one will have to ever open a TAR
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

Posting Permissions

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



Click Here to Expand Forum to Full Width