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
27;t seem to work in this instance. Has
anybody had any success 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
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
>
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 youruserid -p -h hostname dbasename
Regards,
Kelly Black
Linux was very clearly the answer, but what
-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
