Date: Tue, 22 Jan 2002 10:10:06 -0800 (PST) From: "Scott B. Gale" <scott@doheny.beach.net> To: Christian Weihs <whitey@whitey.at> Cc: questions@FreeBSD.ORG Subject: Re: MySQL Trouble PLEASE help! Message-ID: <Pine.BSF.4.21.0201221004150.68620-100000@doheny.beach.net> In-Reply-To: <1a0301c1a2e8$a9a54ea0$a50410ac@olmct.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0201221004150.68620-100000>