At 12:27 -0500 3/1/02, Edward Peloke wrote: >I was thinking more along the lines of creating a db called test and >creating two tables: >test.clients and test2.clients
Huh? Those are two tables in different databases, not two tables in the same database. > >Like you can do in MSSQL, create many table owners in the same db. Well, that's what Victoria said, in effect. You can grant access to multiple people. That's like what you're calling "owners". >-----Original Message----- >From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] >Sent: Friday, March 01, 2002 11:00 AM >To: [EMAIL PROTECTED] >Subject: more than one owner? > > >Edward, >Friday, March 01, 2002, 5:25:23 PM, you wrote: > >EP> Is it possible to specify more than one owner in a mysql db? I want to >EP> create tables with different owners. > >Yes, it's possible. You can specify many users with different grants >on the same database, table, column... > >You should use GRANT statement. For more clarity look at: > http://www.mysql.com/doc/G/R/GRANT.html > >EP> Eddie --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
