> Hello colleagues. Hi,
> How can I global lock a database? > Global means that no user/process should be able to access it; I want to > keep the database > in read only for a certain period, NOT ONLY for the current session. Have a look to Grant and User Privileges. You can create a read only user, put him only select priv, and then use this user for read only ... Or modify an existing user to only set select privilege to him, do you work, and after give him back write access ... http://dev.mysql.com/doc/mysql/en/GRANT.html Hope this help. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
