Grant update permission : Grant Permission « User Previliege « Oracle PL / SQL

1. Oracle PL / SQL
2. User Previliege
3. Grant Permission

Grant update permission

  


create table sprockets (
        id number,
        description varchar2(200),
        quantity    number )
    /

grant update (id, description)
       on sprockets
       to scott;

insert into sprockets (id, description, quantity)
values( 1, 'Titanium', 25 );
    commit;
-- connect scott/tiger
update george.sprockets set quantity = 3;

update george.sprockets set description = 'N';

drop table sprockets;

   
  

Related examples in the same category