<< Click to Display Table of Contents >> Navigation:  Advanced Features > DBWARM > Inside DBWARM > DBWARM Set of protected queries

Set of protected queries

The query files (.SQL) can be protected by inserting at the top of the file a list of declarations like following ones:

.DBWARM_DENIED_TO <group name>
.DBWARM_DENIED_TO <group name>

Each line must start at the first column and its first character must be a dot (.)

Example

Suppose to have the query file LIST_ALL_PARTS.SQL, whose goal is to list all the parts of any project in the database; a sample of such file is:

SELECT * FROM document WHERE t='P' ORDER BY ID

The query is normally accessible by anyone.
If you want to avoid access to this query to any user of the Trainee, Manager and Print group, you must add these lines at the beginning of the file.

DBWARM_DENIED_TO Trainee

DBWARM_DENIED_TO Manager
DBWARM_DENIED_TO Print
SELECT * FROM document WHERE t='P' ORDER BY id