What's the difference between DBA access and read/write access?

Question

I'm setting up a database, but I'm not sure which acess to go with. DBA seems like it would let you do anything, but read/write seems to cover what needs to be done - reading and writing.

I need to know this for a database I'm setting up for an install of Movable Type. Thanks for your help.

Answer 1

Well here a concrete example from my workplace:

Me, a web developer have access to the database and I can read or write on the database as needed (add tables, inserting data, retriving data, etc). This means I have read/write access to the database.

The DBA has all the above rights to the database, but also has some admin rights to the database which I have not. Those rights include but are not limited to:
- Assigning user accounts to the db
- Setting the number of available connections to the db, the size, and other master variables
- Kill db processes
- Sync multiple db machines if u have more than one machine
And other things I might not be aware of.

Long story short, the DBA access takes care of everything that is not data related, but deals with the database engine itself.

Hope this help

Answer 2

DBA Access refers to vaulting applications that keep your info safe. The info is of course encrypted so that it can't be read by others and can only be accessed by you (as the administrator) of your computer or network. Read/Write is a way to keep normal people like you and I from making chances in the files that make a program work properly. If you have editing knowledge, you know how to change the "attributes" that are locking those particular files up so that changes cant be made to them. Once their attributes are removed, editing can be performed on the applications. Sounds confusing I'm sure but I hope that helps. Larry RadioShack 01-9590