read only user [message #317056] |
Tue, 29 April 2008 06:23  |
nani_ar
Messages: 58 Registered: March 2006
|
Member |
|
|
Hi,
I have created a new user and granted him the create session privilege. I have given him the select privileges on another schema's objects. When i try to access the objects,I am able to select the tables, but no data is retrieved. 0 rows are returned. When i check the privileges, the new user is having the select privileges on all objects, but when i select the data, no data is returned. Could you please help me out in this regard
Thanks in Advance
Regards
nani
|
|
|
|
Re: read only user [message #317064 is a reply to message #317059] |
Tue, 29 April 2008 06:43   |
nani_ar
Messages: 58 Registered: March 2006
|
Member |
|
|
Hi Michel,
I forgot to mention that there are rows in the tables. When I select the table by logging as the owner of the table, I am able to see the data. The same is the case with lot of tables. But for some tables, the data is coming and for other tables, the data is not coming. I have granted select privileges on all tables to the new user.
I m in a fuss.
Please help me out.
Regards
nani
|
|
|
|
Re: read only user [message #317076 is a reply to message #317056] |
Tue, 29 April 2008 07:48   |
nani_ar
Messages: 58 Registered: March 2006
|
Member |
|
|
Michel,
Sorry for troubling you. I already informed that there is the data in the tables. I am able to fetch the rows when logged in with the owner of the tables. But when i login with the new user, I dont see any data for the same tables.
For eg. I have table "PAT" in the schema A.
I have given select privileges to schema B(the newly created user)
SQL>grant select on A.PAT to B;
When i try to fetch the rows by logging with B,
SQL>select *from B.PAT;
--------I get no rows.
When I fetch the rows by logging with A,
SQL>select *From PAT;
----I get 25 rows.
Please explain , what could be the problem.
Regards
nani
|
|
|
|
|
|