At 11:19 -0500 4/22/05, Scott Purcell wrote:
I am here in the docs.
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER 'cipher' [AND]]
[ISSUER 'issuer' [AND]]
[SUBJECT 'subject']]
[WITH [GRANT OPTION | MAX_QUERIES_PER_HOUR count |
MAX_UPDATES_PER_HOUR count |
MAX_CONNECTIONS_PER_HOUR count |
MAX_USER_CONNECTIONS count]]
REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON {tbl_name | * | *.* | db_name.*}
FROM user [, user] ...
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...
I have a database with tables, and I want to set up a "user" with a
"password" that I can use to display this database and tables in a
webapp.
I do not want to use the root/password for connecting. So the docs
say to use this command. Problem is I cannot find what to put in for
the priv_type and I am unclear exactly how to pull this together. If
all tables are allowed to be used can someone help me out with this?
If you want the account to have read-only access, priv_type should be
SELECT.
GRANT SELECT ON db_name.* TO 'some_user'@'some_host'
IDENTIFIED BY 'some_password';
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
