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

GRANT All Table Privileges Authorization

To grant all table privileges, one of the following must be true:

• You hold all privileges on the table-like object as grantable privileges. (you can grant the privileges, but you cannot specify WITH GRANT OPTION)
• You own the table-like object.
• You hold DBADMIN privilege the application dictionary where the table-like object is defined and on the database that contains the table-like object data.
• You hold SYSADMIN privilege.