Oracle PL/SQL/User Previliege/Table privileges

Grant permission for a table to a user

 
grant select on mytable to scott with grant option;

Grant select on a table with synonym

 
connect scott/tiger
grant select on george.mytable to system;

Grant the CREATE TABLE privilege to DROPME

 

grant create session, create table  to dropme;

Grant with user name and table name

GRANT SELECT ON Student.ClassEnrollment TO Susan
WITH GRANT OPTION;

Table privileges: SELECT, ALTER, DELETE, INSERT, and UPDATE

 
GRANT DELETE ON bonuses TO userName

--