I have installed Oracle 11g on fedora 14. I connected with SQL*Plus as 'SYS' and created some tables, then created a user named "account" and a role, "payroll" with the following privileges. I assigned the role to the "account" user but I cannot access the created tables when I log-in as "account".
Here are my queries:
As SYS
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:
select * from pay;
This gives me an error saying there is no such table or view.