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