Grant select on a table with synonym : Table privileges « User Previliege « Oracle PL / SQL






Grant select on a table with synonym

 

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

 








Related examples in the same category

1.Table privileges: SELECT, ALTER, DELETE, INSERT, and UPDATE
2.Grant with user name and table name
3.Grant the CREATE TABLE privilege to DROPME
4.Grant permission for a table to a user