SELECT
, INSERT
, UPDATE
, DELETE
, and ALTER
. Alternatively, ALL can be
specified if all of the above actions are to be taken away from the
user.Example: The Personnel clerks no longer need to access the EMPLOYEE table. Revoke their privileges as follows:
REVOKE UPDATE, INSERT
ON EMPLOYEE
FROM CLERK1, CLERK2 ;
This completes the discussion of security features in Texis. In the next chapter, you will be introduced to certain other administrative features that can be implemented in Texis.