SQL permissions

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

My database is Access and i try to use : REVOKE AND GRANT i try:

$queryHandle = $dbshop->prepare(" GRANT SELECT ON Table to John ");  
$queryHandle->execute() or die;
[download]

and got the below error: " DBD::ODBC::db prepare failed: Microsoft ODBC Microsoft Access Driver Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. "

Comment on SQL permissions Download Code

Replies are listed 'Best First'.
Re: SQL permissions by Anonymous Monk on Jul 15, 2009 at 11:24 UTC
What is your question? Invalid SQL statement; means your database doesn't support (or doesn't give permission) for REVOKE/GRANT.	[reply]