User Permissions Issue (Easy questions?)

2001-10-01 Thread Erica Douglass
Hi, I am working with an internal database. We add a user using the following statements: create database name_of_database; GRANT alter, create, delete, drop, insert, select, update, index ON name_of_database TO username@localhost identified by password with grant option; GRANT alter, create,

Re: User Permissions Issue (Easy questions?)

2001-10-01 Thread Curtis Maurand
grant alter, create, delete, drop, insert, select, update, index ON name_of_database.* to name_of_database TO username@localhost identified by password with grant option; then grant alter, create, delete, drop, insert, select, update, index ON name_of_database.* to name_of_database TO

RE: User Permissions Issue (Easy questions?)

2001-10-01 Thread Erica Douglass
Thank you so much! That worked. *big sigh of relief* Erica -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 12:48 PM To: Erica Douglass Subject: RE: User Permissions Issue (Easy questions?) Hi, I am working