saurabh18cs
Honored Contributor III
-- Grant SELECT, INSERT, UPDATE, DELETE permissions on the table
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE db_bronze.<table> TO `user@example.com`;

-- Grant ALL PRIVILEGES on the database
GRANT ALL PRIVILEGES ON DATABASE db_bronze TO `user@example.com`;

-- Grant OWNERSHIP on the table
GRANT OWNERSHIP ON TABLE db_bronze.<table> TO `user@example.com`;