To search our online Knowledge Base for examples that have CREATE VIEW sample SQL code. > p/wwhimpl/common/html/wwhelp.htm?context=dmsrf&file=01dmsrftitle.html It has the syntax and examples of how to create a view against any table. Following is the online documentation for OpenEdge SQL. OpenEdge SQL Views may be created using any ODBC or JDBC client. Subject: Re: SQL Views and Progress 10.2bĭen 12. See for instructions on how to configure the DBVisualizer with OpenEdge.įrom: Geir Otto Olsen [mailto: Wednesday, J3:49 PM
The free version allows you to execute one statement at a time. Amongst the free JDBC clients, I like DbVisualizer from. Notice the GO in WinSQL is the same as COMMIT in JDBC syntax.Ģ. For example:ĬREATE VIEW yshanshi.Customer_View AS SELECT Name, Address, City, State FROM pub.Customer GO GRANT SELECT ON yshanshi.Customer_View TO PUBLIC GO This tool allows you to execute multiple statements. You can download the 30 day evaluation and keep the free version after the 30 days. Amongst the free ODBC clients, I like WinSQL from. I only want the user 'incita' to have select possibilities for only tables and views, not hidden tables.įra: Youssif Shanshiry [mailto: 12. I really don't want to add DBA to a view user, so how do I give correct permissions? If I don't do the following sentence, it does not work Grant select on incita.AvdelingPRK to 'incita' WHERE dsRegnskapstall_0.dsAvdelingObj = dsAvdeling_0.dsAvdelingObj AND dsKonto_0.AcNo = dsRegnskapstall_0.AcNo AND dsKonto_0.dsKontoGruppeObj = dsKontoGruppe_0.dsKontoGruppeObj SELECT dsRegnskapstall_0.AcNo, dsRegnskapstall_0.Yr, dsRegnskapstall_0.Pr, dsRegnskapstall_0.Resultat, dsRegnskapstall_0.Balanse, dsAvdeling_0.Avdelingnavn, dsKonto_0.Kontonavn, dsKontoGruppe_0.KontoGruppeNavnįROM dsAvdeling_0,ĭ dsKontoGruppe_0,ĭ dsRegnskapstall_0
Youssif, could you tell me how to add GRANT to the VIEWS ?
0 kommentar(er)
