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?
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
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?
Re: Access Rights of database
By default they don't have access privilege on other users' data
---James
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?
Re: Access Rights of database
My suggestion to u is read oracle standard documentation. That is the best one.
-- James