I was thinking more along the lines of creating a db called test and creating two tables: test.clients and test2.clients
Like you can do in MSSQL, create many table owners in the same db. -----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 -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
