From owner-freebsd-questions Tue Jan 22 10: 9:59 2002 Delivered-To: freebsd-questions@freebsd.org Received: from doheny.beach.net (doheny.beach.net [206.16.184.191]) by hub.freebsd.org (Postfix) with ESMTP id DC21E37B400 for ; Tue, 22 Jan 2002 10:09:56 -0800 (PST) Received: from localhost (scott@localhost) by doheny.beach.net (8.11.3/8.11.3) with ESMTP id g0MIA7i69059; Tue, 22 Jan 2002 10:10:07 -0800 (PST) Date: Tue, 22 Jan 2002 10:10:06 -0800 (PST) From: "Scott B. Gale" To: Christian Weihs Cc: questions@FreeBSD.ORG Subject: Re: MySQL Trouble PLEASE help! In-Reply-To: <1a0301c1a2e8$a9a54ea0$a50410ac@olmct.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Mon, 21 Jan 2002, Christian Weihs wrote: > Hi, > I don't know MySQL much myself but don't you have to grant > users rights directly on tables? No, you may grant privileges at the global, database, table, or column level. From the documentation at http://www.mysql.com/doc/G/R/GRANT.html: *********************************************************************** The GRANT and REVOKE commands allow system administrators to create users and grant and revoke rights to MySQL users at four privilege levels: Global level Global privileges apply to all databases on a given server. These privileges are stored in the mysql.user table. Database level Database privileges apply to all tables in a given database. These privileges are stored in the mysql.db and mysql.host tables. Table level Table privileges apply to all columns in a given table. These privileges are stored in the mysql.tables_priv table. Column level Column privileges apply to single columns in a given table. These privileges are stored in the mysql.columns_priv table. *********************************************************************** Scott B. Gale Dana Point Communications To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message