Results 1 to 6 of 6

Thread: Access Rights of database

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    72

    Access Rights of database

    System administrator as far, as I know, administers the whole system or database. So does it mean that he have full access to all databases. I want to whether it is possible for me to make my MYSQL database not accessible to the system administrator. If so tell me how to achieve this?


  2. #2
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: Access Rights of database

    DBA has control over your database. But they don't have access to your data.
    DBA can access your data if an only if you grant access privilege to him/her.

    --- James


  3. #3
    Contributing Member
    Join Date
    May 2006
    Answers
    72

    Re: Access Rights of database

    Thanks for the reply. So is it that the way giving access or privilege to data for DBA is in the same way as we do for other users? By default will they have access or not?


  4. #4
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: Access Rights of database

    By default they don't have access privilege on other users' data


    ---James


  5. #5
    Contributing Member
    Join Date
    May 2006
    Answers
    72

    Re: Access Rights of database

    Ok thanks for the information. I want to learn more on security details of database, access levels in database. Can you tell me some books or online reference for knowing these details?


  6. #6
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: Access Rights of database

    My suggestion to u is read oracle standard documentation. That is the best one.

    -- James


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact