At 11:19 -0500 4/22/05, Scott Purcell wrote:
I am here in the docs.
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON {tbl_name | * | *.* | db_name.*}
TO user [IDENTIFIED BY [PASSWORD] 'password']
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
[snip]
Is it possible to grant all these databases in just one GRANT instruction
such as:
GRANT SELECT,INSERT,UPDATE,DELETE ON dbexample*.* TO 'user'@'localhost' BY
'password';
[/snip]
GRANT [privs] ON `dbexample%`.* TO 'user'@'localhost' IDENTIFIED BY
'password';
---
Tom Crimmins
Interface Spec
At 9:31 + 2/23/04, [EMAIL PROTECTED] wrote:
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
I am new to most aspects of MySQL administration so I was wondering
if someone can help me figure out what GRANTs I need for a
particular situation.
I have a user who needs to be able to r
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
> I am new to most aspects of MySQL administration so I was wondering
> if someone can help me figure out what GRANTs I need for a
> particular situation.
>
> I have a user who needs to be able to run some MySQL scripts that
> create
At 14:56 -0500 2/21/04, Rhino wrote:
Thanks, that clears things up pretty well.
By the way, since you're on the documentation team, can you tell me what the
"official channels" are for making suggestions about the documentation. I
have some ideas about how to make it better
Mail to [EMAIL PROT
Thanks, that clears things up pretty well.
By the way, since you're on the documentation team, can you tell me what the
"official channels" are for making suggestions about the documentation. I
have some ideas about how to make it better
Rhino
--
MySQL General Mailing List
For list archiv
At 14:30 -0500 2/21/04, Rhino wrote:
More followups below
> >> > 1. Why is this happening? The Load Data article says he needs the
File
>privilege and I've given it to him. He also has all privileges on the NFL
>database. What more do I need to do for him?
>>
>> FILE is a global level
More followups below
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 1:25 PM
Subject: Re: GRANT question
> At 13:09 -0500 2/21/04, Rhino
At 13:09 -0500 2/21/04, Rhino wrote:
Followup questions interspersed below
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 12:29 PM
Subject: Re: GRANT question
"Rhino" <[EMAI
Followup questions interspersed below
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 21, 2004 12:29 PM
Subject: Re: GRANT question
> "Rhino" <[EMAIL PROTECTED]> wro
"Rhino" <[EMAIL PROTECTED]> wrote:
> I am new to most aspects of MySQL administration so I was wondering if someone can
> help me figure out what GRANTs I need for a particular situation.
>
> I have a user who needs to be able to run some MySQL scripts that create and load
> tables in a database
Hi,
Yes, you're right. GRANT and REVOKE do not need FLUSH PRIVILEGES afterwards.
Flushing is only needed when manually updating the grant tables via normal
INSERT/UPDATE/DELETE commands.
Regards,
Iikka
On Wed, 2 Oct 2002 [EMAIL PROTECTED] wrote:
> If i use GRANT and REVOKE to change user privi
Another grant command for the existing privileges + index privs. should work
Bhavin.
- Original Message -
From: "Paul Maine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 24, 2002 5:33 PM
Subject: RE: Grant question
> I have an existing mysq
: Wednesday, July 24, 2002 6:27 PM
To: Paul Maine
Subject: Re: Grant question
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this
14 matches
Mail list logo
