Thread: Scan SQL
Hi I need to make a parser in a sql to get tables and fields to verify the privileges. Do anybody know software, function or anything that can help me? I found software to create a compiler and generate the source in delphi, but I need a sql specification (BNF, EBNF) and I do not know where to find it. Thanks Sandro
Sandro, > I need to make a parser in a sql to get tables and fields to verify > the > privileges. Do anybody know software, function or anything that can > help me? I probably can, but I'm not quite sure what you're asking for. Could you explain at greater length, maybe with some examples? -Josh Berkus
On Tue, Jul 23, 2002 at 10:11:18AM -0300, Sandro Joel Eller wrote: > Hi > > I need to make a parser in a sql to get tables and fields to verify the > privileges. Do anybody know software, function or anything that can help me? > > I found software to create a compiler and generate the source in delphi, but I > need a sql specification (BNF, EBNF) and I do not know where to find it. You could look at how PostgreSQL does its parsing. The source code is open. -Roberto -- +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer I to¤d yo¤, "Never¤touch ¤he flo¤py di¤k su¤face!"
On Tue, 23 Jul 2002, Roberto Mello wrote: > On Tue, Jul 23, 2002 at 10:11:18AM -0300, Sandro Joel Eller wrote: > > Hi > > > > I need to make a parser in a sql to get tables and fields to verify the > > privileges. Do anybody know software, function or anything that can help me? > > > > I found software to create a compiler and generate the source in delphi, but I > > need a sql specification (BNF, EBNF) and I do not know where to find it. > > You could look at how PostgreSQL does its parsing. The source code is > open. > > -Roberto Check out src/backend/parser/*.y for full YACC grammars. Joshua b. Jore ; http://www.greentechnologist.org
Josh The good, will be, see the sample below, return field list and table list of the sql and to analyse it to give permission or not to open the table in delphi. select a, b, c, d from z, x Sandro ----- Original Message ----- From: "Josh Berkus" <josh@agliodbs.com> To: "Sandro Joel Eller" <sandro@tecsoft.com.br>; <pgsql-sql@postgresql.org> Sent: Tuesday, July 23, 2002 3:40 PM Subject: Re: [SQL] Scan SQL > Sandro, > > > I need to make a parser in a sql to get tables and fields to verify > > the > > privileges. Do anybody know software, function or anything that can > > help me? > > I probably can, but I'm not quite sure what you're asking for. Could > you explain at greater length, maybe with some examples? > > -Josh Berkus > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster