TECTED]>13/11/2003 11:35 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS
You can't login as testuser and try to give yourself privileges, it just
doesn't work.
Paul DuBois <[EMAIL PROTECTED]>13/11/2003 11:14 AM
To: BORNAY Richard/Engr/STATS/ST [EMAIL PROTECTED] Domain, [EMAIL PROTECTED]
cc:
Subject: RE: GRANT TO SELECTED COLUMNS
At 10:55 AM +0800 11/13/03, [EMAIL PROTECTED] wrote:
>Hi Chris/Lists,
>In fact, I was able to
the Select privilege FROM
mysql.tables_priv.Table_priv WHERE User='testuser' AND Host='%'
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 6:56 PM
To: [EMAIL PROTECTED]
Subject: RE: GRANT TO SELECTED COLUMNS
nly those two columns.
In that case, SELECT * should work. But my impression is that your
table has more than just the two columns.
"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/S
the error Access denied for user
'testuser'
Thanks, Richard
"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM
To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS
That second query, byt itself, should have done it, were you logged in as
testuser when you tried to run it?
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: GRANT TO SELECTED COLUMNS
Hello List,
I have a table named CHECK_SBIN with fields id,jobid,filename,sbin,count,
then I would like to create an account lets say testuser with SELECT
privileges only to a specific columns. In this case I would like to open
only id and jobid to 'testuser'.
I have already created an account t