Correct. Carlos
On Tue, Jan 31, 2012 at 12:03 AM, kalin m <ka...@el.net> wrote: > > > 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 > > > > >
