>On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
>> I can't get table-specific grants to work.
>>
>
>
>
>Have you "flush privileges" ?
Yes. That didn't change it.
Nicholas
---
I can't get table-specific grants to work.
(FIRST: I log in as an administrator and run the following command:)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON myDataBase.watch TO '%';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT * FROM tables_priv;
+--++--++
Easier yet, when using DBI::mysql, is:
my $IncrementedID = $dbh->{'mysql_insertid'};
When executed after the INSERT command.
Nicholas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 9:28 AM
To: 'Ben Curran'; [EMAIL PROTECTED]
Subject:
It should be PrintError (capital 'E').
ie.
---
$dbh = DBI->connect($dsn, $user, $pwd,{PrintError =>
0, RaiseError => 1});
Nicholas
-Original Message-
From: Investor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 2:43 PM
To: [EMAIL PROTECTED]
Subject: Error with code utilizin
Sinisa Milivojevic writes:
>
>ALTERing will completely break security and permission systems and
>will even prevent MySQL from proper functioning.
>
Can you give me an example? I'm having no problems with security even after adding
these columns. Users only have access to the dbs and tables th
I have added some extra fields to the mysql.user table, namely:
full_name VARCHAR(255)
job VARCHAR(255)
location VARCHAR(255)
phone VARCHAR(255)
reminder VARCHAR(255) NOT NULL
ip_addr VARCHAR(255) NOT NULL
I want to store these values for each person that creates a new account on my database.
Th
