t: Re: granting privileges using wildcards
On Wed, 26 Mar 2003 14:37:33 -0800
Jennifer Goodie wrote:
> To answer the original question, I have tried a lot of different
ways, but
> the only solution I have found is granting on the entire database
or
> specifing each table in the table
OTECTED]
Subject: RE: granting privileges using wildcards
That would grant the user select on everything in every database no matter
what host they are coming from. He wants to only grant on specific tables,
and did not mention anything about allowing from all hosts.
To answer the original ques
ccess with it?
-Original Message-
From: Black, Kelly W [PCS] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 11:14 AM
To: 'Dimitar Haralanov'; [EMAIL PROTECTED]
Subject: RE: granting privileges using wildcards
I think this might do what you want, but then you will be
On Wed, 26 Mar 2003 14:37:33 -0800
Jennifer Goodie wrote:
> To answer the original question, I have tried a lot of different
ways, but
> the only solution I have found is granting on the entire database
or
> specifing each table in the tables_priv table. I go with the
second option
>
the answer, but what was the question again?
-Original Message-
From: Dimitar Haralanov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 11:03 AM
To: [EMAIL PROTECTED]
Subject: granting privileges using wildcards
Hi,
I have been trying to find information on th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dimitar --
...and then Dimitar Haralanov said...
%
...
% Basically, is something like the following possible?
%
% GRANT SELECT ON db.table_% TO user@'%' IDENTIFIED BY 'pass';
AFAIK it is not. See Benjamin's quite thorough response to my
Is there a reason for not using tables_priv table for this purpose?
Mihail
- Original Message -
From: "Dimitar Haralanov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 26, 2003 2:29 PM
Subject: Re: granting privileges using wildcards
On Wed
On Wed, 26 Mar 2003 13:14:09 -0600
Black, Kelly W [PCS] wrote:
> I think this might do what you want, but then you will be required
to log
> in with the -p syntax...
>
> GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY "somepassword";
>
> FLUSH PRIVILEGES;
>
> mysql -u
Hi,
I have been trying to find information on the following question but
have been unable to do so:
Is it possible to grant options to a user using wildcards. For example:
let's say that I have a database named 'db', and a user 'admin' who has
full privileges. The user 'ad
