GRANT user_privilege ON table_name TO username or role_name ;
The possible user privileges on tables are SELECT, INSERT, DELETE, UPDATE, REFERENCES and ALL. ALL provides a user or a role all five privileges mentioned above. A new user has no privileges until they are granted.
The following example grants INSERT and DELETE privileges on a table named TEST_TABLE to the GUEST_USERS role.
GRANT INSERT, DELETE ON TEST_TABLE TO GUEST_USERS;
The EXECUTE privilege provides a user the right to execute a stored procedure:
GRANT EXECUTE ON procedure_name TO username or role_name ;
The following example grants EXECUTE privilege on a stored procedure named
SP_TEST to user CALVIN. GRANT EXECUTE ON SP_TEST TO CALVIN;