GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON [db_name].* TO '[db_user]'@'[db_host]' IDENTIFIED BY '[db_user_password]';From that script, if you want to limit user privileges just on manipulating data, you should use select, insert, update, delete.
procedure Alert_Xls(AXLSFile: string);
const
xlCellTypeLastCell = $0000000B;
var
XLApp, Sheet: OLEVariant;
RangeMatrix: Variant;
x, y, k, r: Integer;
begin
XLApp := CreateOleObject('Excel.Application');
try
XLApp.Visible := False;
XLApp.Workbooks.Open(AXLSFile);
Sheet := XLApp.Workbooks[ExtractFileName(AXLSFile)].WorkSheets[1];
Sheet.Cells.SpecialCells(xlCellTypeLastCell, EmptyParam).Activate;
x := XLApp.ActiveCell.Row;
y := XLApp.ActiveCell.Column;
RangeMatrix := XLApp.Range['A1', XLApp.Cells.Item[X, Y]].Value;
k := 1;
repeat
for r := 1 to y do
//this section to operate data, change as your need
ShowMessage(RangeMatrix[K, R]);
Inc(k, 1);
until k > x;
RangeMatrix := Unassigned;
finally
if not VarIsEmpty(XLApp) then
begin
XLApp.Quit;
XLAPP := Unassigned;
Sheet := Unassigned;
end;
end;
end;
<a href="http://www.blogger.com" onclick="window.open(http://www.google.com)">2 Link 1 click</a>
Copy d:\i386\ntldr c:\ Copy d:\i386\ntdetect.com c:\
var myObject = {nations: [
{name: "England", continent: "Europe"},
{name: "USA", continent: "America"},
{name: "JAPAN", continent: "Asia"}
]
};
This posting will discuss about creating JSON from PHP-Mysql Database driven application. The following is the step to do that :$query = "select * from country";
$parse = mysql_query($query);
while($row = mysql_fetch_object($result)){
$result[] = $row;
}
var myString = '<?php json_encode($result);?>';
var myObject = eval('(' + myString + ')');
require_once ('fpdf.php');
$pdfObj = new FPDF();
$pdfObj->AddPage();
$pdfObj->SetFont('Tahoma','B',16);
$pdfObj->Cell(90,10,'Hello World!');
$pdfObj->Output();
 |
 |
| print blog |
