I'm glad that worked for you the manual should be updated with clearer
examples..
-Martin
Allan Bakke was right!
- Original Message -
From: "Tiffany Wilkes" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, August 05, 2003 3:48
FYI
Note on this. Using column privs you take a performance penalty on reads
/ writes.
-->-Original Message-
-->From: Tiffany Wilkes [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, August 05, 2003 3:48 PM
-->To: mysql
-->Subject: column privilege problem--Solved
-->
-->
Wilkes [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, August 05, 2003 3:48 PM
-->To: mysql
-->Subject: column privilege problem--Solved
-->
--> I solved the problem--I needed ( ) around the column list. I think
-->the manual should make that more clear.
-->
--> Origina
Hi,
I am having problems granting column privileges. I want to grant the
update privilege (only) to a column (called pass) in a table (called
Acct). Here's what I get:
mysql> grant update pass on practicedb.Acct to [EMAIL PROTECTED];
ERROR 1064: You have an error in your SQL syntax near 'pass
Tiffany Wilkes <[EMAIL PROTECTED]> wrote:
>
> I am having problems granting column privileges. I want to grant the
> update privilege (only) to a column (called pass) in a table (called
> Acct). Here's what I get:
>
> mysql> grant update pass on practicedb.Acct to [EMAIL PROTECTED];
> ERROR 1
I solved the problem--I needed ( ) around the column list. I think
the manual should make that more clear.
Original Message
Subject: column privilege problem
Date: Tue, 05 Aug 2003 15:39:54 -0700
From: Tiffany Wilkes <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Hi,
I am having a problem with a user having the correct privleges in mysql.
The user cannot connect to get access to the database, but everything looks correct to
me.
User table...
Host User Password Privs
localhostuser1password Only Y is for File_priv
ip_a
...And you have checked that permissions have been set correctly, both in
MySQL and at the OS level.
- Original Message -
From: "Leon Zilber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 13, 2001 3:27
Subject: privilege problem
> I am not
I am not sure I am encoutering the following problem
when I try to access the database?
java.sql.SQLException: Server configuration denies
access to data source
java.sql.SQLException: Server configuration denies
access to data source
My java program defines: user and a password and when
I connect
