The following statement revokes the Update privilege on the fragment of the customer table in part1 from user ed:
REVOKE FRAGMENT UPDATE ON customer (part1) FROM ed
The following statement revokes the Update and Insert privileges on the fragment of the customer table in part1 from user susan:
REVOKE FRAGMENT UPDATE, INSERT ON customer (part1) FROM susan
The following statement revokes all privileges currently granted to user harry on the fragment of the customer table in part1:
REVOKE FRAGMENT ALL ON customer (part1) FROM harryEnterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]