---------as SYS user------------------------------------------------------------------------- create type pay_t as object( id int, name varchar(10) ) / create table pay of pay_t; insert into pay values(pay_t(10,'p01')); ------------------------------------------ create user account identified by paccount; grant create session to account; grant connect to account ------------------------------------------ create role pay_roll; grant select on pay to pay_roll; grant pay_roll to account; -------------------------------------------------------------------------------------------- --------------as account user--------------------------------------------------------------- select * from pay;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)