SQL Restrictions Use the SQL Restrictions option to prevent certain types of SQL statements from being executed on a database connection. Listed below are the types of SQL statements RazorSQL does not allow for each of the types of SQL restrictions. If a command is issued that RazorSQL does not recognize, it is generally allowed. The following are the types of SQL Restrictions RazorSQL provides: 1. None: All types of SQL statements are allowed. 2. Read Only: Does not allow the following: UPDATE INSERT UPSERT MERGE DELETE TRUNCATE CREATE ALTER DROP RENAME GRANT REVOKE 3. Read / Write: Does not allow the following: DELETE TRUNCATE CREATE ALTER DROP RENAME GRANT REVOKE 4. Read / Write / Delete: Does not allow the following: CREATE ALTER DROP RENAME GRANT REVOKE |
|