Removing Privileges

Privileges assigned to other users can be taken away by the person who granted them. In TEXIS, the REVOKE statement would be used to remove privileges granted by the GRANT command. The general form of this statement is:

     REVOKE  [ALL]
             privilege1 [,privilege2] ...
     ON      table-name1
     TO      PUBLIC
             userid1 [,userid2] ... ;

• Command Discussion