Syntax for Securing Database Resources › GRANT All Table Privileges › GRANT All Table Privileges Usage

GRANT All Table Privileges Usage

Verification of Wildcarded Grants

When you grant all table privileges, you grant a combination of table access and table definition privileges. If you wildcard table-name, the verification at runtime of the user's access privilege is handled differently from verification of the user's definition privilege:

• For definition privileges, only the closest matching wildcarded grant is used. If CREATE privilege has been granted on HR.EMP* and HR.EMPV*, then only the grant on HR.EMPV* is used to verify the privilege to create HR.EMPVU_SALARY.
• For access privileges, all matching wildcarded grants are used. If SELECT privilege has been granted on HR.EMP* and HR.EMPV*, then users or groups receiving either the HR.EMP* or the HR.EMPV* grant are authorized to select from EMPVU_SALARY.

Granting All Privileges to All Users

The following GRANT statement gives all users all privileges on all table-like objects in the TEST schema:

grant all privileges
   on test.*
   to public;