i have installed oracle 11g on fedora 14. i connected to sqlplus as 'SYS' and
create some table, then create user named as "account" and create role as "payroll"
with the following privillages. then assign the roll to the "account" user. but i
still can not access the created tables when i loggedas user "account". here is my quaries.
plz can anyone help
create type pay_t as object(
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;
select * from pay;
this gives an error saying there are no such table or view.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)