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> 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
>
>
