privilleges

Hi,

DB: Mysql
Platform: Linux -- NetBSD

I have a database and abt 60 users, where there are user accounts for them. I would like them to create, delete, modify, update, insert,drop ..etc tables in their database only. For example DB1 user can do all those things in their database only.
How should I do that ?

I have look into the user table in mysql DB, and I found for all these users, their privilleges are set to 'N". But they are still able to create tables in their own database. Why so ?

thanks for ur contribution

Rathaur

Did you issue "flush privileges" after modifying the table? Check out mysql.com for the complete reference guide.

There are two tables in the "mysql" database you need to take note of.

1. "user" table.
This table does hold user information ( username, password, host). This is all you need to be concerned about in your case. All the other fields are set to 'N' because you don't want to give any of these users global database access. Any access priviledge in this table is effective for ANY database on the server. You probably don't want this.


2. "db" table.
This table will list the host, database name, and user that can access it. It also specifies which actions that user can take on that particular database. I know it is a little complex, however, it is very powerful IMHO.

Now you have two choices... Modify the "db" table directly with an UPDATE db SET... sql query or use the GRANT commands.


I find it useful to flush privileges either way after one of these actions.

thanks i got it ...