thanks carlos. so if i go with:
"grant file on user.... " that wont infringe on the all other privileges the user already has, correct? thanks.. On 1/31/12 12:47 AM, Carlos Proal wrote: > Hi, > > You have look at the "user" table which has global privileges, "db" is > specific to each database. > > Carlos > > > On Mon, Jan 30, 2012 at 10:56 PM, kalin m <ka...@el.net > <mailto:ka...@el.net>> wrote: > > > > hi... > > so i have this user in the user table in the mysql db that has all the > privileges but "grant". now i need for that user to have the "file" > privilege so it can do "into outfile". thing is i don't see that > privilege anywhere in the db table. i know that i have to do the "grant > file on user@localhst" thing but what table does that write to? > also if i have all the other privileges granted and just need to add the > "file" one, do i have to re-grant all the rest of those or it'd just add > the "file" privilege to all the already granted ones? > > the tables_priv, columns_priv and procs_priv don't have any "file" > privilege listed. > > this is the list of privileges i can see off the db table: > > | Select_priv | enum('N','Y') > | Insert_priv | enum('N','Y') > | Update_priv | enum('N','Y') > | Delete_priv | enum('N','Y') > | Create_priv | enum('N','Y') > | Drop_priv | enum('N','Y') > | Grant_priv | enum('N','Y') > | References_priv | enum('N','Y') > | Index_priv | enum('N','Y') > | Alter_priv | enum('N','Y') > | Create_tmp_table_priv | enum('N','Y') > | Lock_tables_priv | enum('N','Y') > | Create_view_priv | enum('N','Y') > | Show_view_priv | enum('N','Y') > | Create_routine_priv | enum('N','Y') > | Alter_routine_priv | enum('N','Y') > | Execute_priv | enum('N','Y') > | Event_priv | enum('N','Y') > | Trigger_priv | enum('N','Y') > > > thanks... > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
