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