phil benson wrote: > > Please could someone tell me what the difference is between these two > states, and why you would use admin state. > > As far as I understand at the moment, when the database is in 'ADMIN' > state, > it cannot be queried. This state is used for adding new users. > > Once in 'ONLINE' state, the database can be queried, but new users (and > other administrative tasks) cannot be completed. >
ONLINE-state: for all SQL-statements which can be found in the reference manual, like select, insert, update, delete, create table, drop view and so on and so on and even create user, drop user, alter user (chapter Authorization) meaning the definition of SQL-users, e.i. users able to connect to the database kernel. And even some administrative tasks can be done in ONLINE-mode: changing of some parameter, backup, some checks. ADMIN-state: for some administrative tasks, like recovery of the database. Elke SAP Labs Berlin > Thanks, > > Phil > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 2/10/2005 > > > > > This e-mail was scanned for viruses using BitDefender > *********************************** > Please note - If you have recieved this message in error, and are not the > intended recipient, please contact Vebra Solutions Ltd 0845 1305444 / > 01759 305374. > Thank you. > *********************************** > > ________________________________________________________________________ __ > __ > This email and all attachments have been electronically scanned by > Kingston > Communications' email Anti-Virus service and no known viruses were > detected. > ________________________________________________________________________ __ > __ > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
