Difference between revisions of "Common:SQL Safety Note"

From AgileApps Support Wiki
imported>Aeric
(Created page with "{{Note|When you make a SQL query, you are not querying the platform database directly. Rather, you are querying a role-permissions restricted ''view'' of the database, so the rec…")
 
imported>Aeric
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Note|When you make a SQL query, you are not querying the platform database directly. Rather, you are querying a role-permissions restricted ''view'' of the database, so the records and fields you can see using SQL are the same as those you see when using the GUI. In addition, SQL injections are expressly disallowed, so the database view remains intact.}}
{{Note|<br>When you make a SQL query, you are not querying the platform database directly. Rather, you are querying a ''view'' of the database that is restricted by your role permissions, so the records and fields you can see using SQL are the same as those you see when using the GUI. In addition, the platform implements various safeguards to prevent SQL Injection attacks.}}

Latest revision as of 19:53, 15 December 2011

Notepad.png

Note:
When you make a SQL query, you are not querying the platform database directly. Rather, you are querying a view of the database that is restricted by your role permissions, so the records and fields you can see using SQL are the same as those you see when using the GUI. In addition, the platform implements various safeguards to prevent SQL Injection attacks.