Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Linux Oracle
hi,
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
---------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;
this gives an error saying there are no such table or view.
Posted 16-Mar-13 3:38am
Edited 17-Mar-13 4:46am
(no name)498.5K
v2
Comments
Sudhakar Shinde at 16-Mar-13 22:22pm
   
Table pay is created under SYS user and hence it will not get accessed under account. It will be better if you can explain what are you trying to achieve by creating a user and roll then we can help with some solution.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 562
1 Sergey Alexandrovich Kryukov 484
2 Maciej Los 325
3 DamithSL 233
4 Mathew Soji 195
0 OriginalGriff 7,168
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,461
3 Manas Bhardwaj 4,876
4 Maciej Los 4,450


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 17 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100