How can I prevent user oracle from accessing a database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How can I prevent user oracle from accessing a database

  1. #1
    Join Date
    Oct 2001
    Posts
    9

    Unhappy How can I prevent user oracle from accessing a database

    I have 3 databases running on a Sun Server and want to create the fourth one. However, I don't want anyone except user HR to to access this Database. All of the DBAs have user oracle access to the Server
    thank you in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    on install of the Oracle softaware you could set the sysdba groups and sysoper group to be that of this HR user and then create this database under that Oracle home.

    Why would yu not want your dba's to log onto this database? how are they going to fix it if it goes down?

  3. #3
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    When you create the 4th database, don't recreate all the users ...

    or if the users are already there ... lock the account
    ie; ALTER USER DAVID account lock;

    Hope this helps
    Gregg

  4. #4
    Join Date
    Oct 2001
    Posts
    9

    You are mavolous

    Originally posted by davey23uk
    on install of the Oracle softaware you could set the sysdba groups and sysoper group to be that of this HR user and then create this database under that Oracle home.

    Why would yu not want your dba's to log onto this database? how are they going to fix it if it goes down?

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by davey23uk
    how are they going to fix it if it goes down?
    There's the key point -- you have to have at least one dba user.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Oct 2001
    Posts
    9
    Thanks!!!

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