Which role(s) can alter or drop table XYZ?

The following SQL command was executed: Use role SECURITYADMIN; Grant ownership On future tables In schema PROD. WORKING To role PROD_WORKING_OWNER; Grant role PROD_WORKING_OWNER to role SYSADMIN; Use role ACCOUNTADMIN; Create table PROD.WORKING.XYZ (value number); Which role(s) can alter or drop table XYZ?A . Because ACCOUNTADMIN created the table, only...

January 18, 2024 No Comments READ MORE +