Re: write-protection for some tables while other are writable

2006-08-24 Thread Jon Molin
On 8/23/06, Gregor Reich [EMAIL PROTECTED] wrote: Hi all Is there a possibility to have some tables write-protected while others in the same db are not (and yet the write-protected ones are updatable through the replication mechanism, ie. there are tables on a slave server). I guess that both,

Re: write-protection for some tables while other are writable

2006-08-24 Thread Gregor Reich
Vielen Dank für die Hinweise; grant ... wird mir weiterhelfen. Gruss, Gregor. Dominik Klein schrieb: Guten Morgen Gregor beim nächsten mal antworte bitte an die Liste. Beispiel: User gregor soll auf datenbank.tabelle1 nur lesend zugreifen können, auf datenbank.tabelle2 auch schreibend.

write-protection for some tables while other are writable

2006-08-23 Thread Gregor Reich
Hi all Is there a possibility to have some tables write-protected while others in the same db are not (and yet the write-protected ones are updatable through the replication mechanism, ie. there are tables on a slave server). I guess that both, LOCK TABLES and read-only in my.cnf, don't get

Re: write-protection for some tables while other are writable

2006-08-23 Thread Dominik Klein
Is there a possibility to have some tables write-protected while others in the same db are not (and yet the write-protected ones are updatable through the replication mechanism, ie. there are tables on a slave server). I guess that both, LOCK TABLES and read-only in my.cnf, don't get this