| read only user [message #317056] |
Tue, 29 April 2008 06:23  |
nani_ar
Messages: 42
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 #317059 is a reply to message #317056 ] |
Tue, 29 April 2008 06:34  |
Michel Cadot
Messages: 15225
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
There is no row in the tables.
More seriously, as you don't post what you really did, it is impossible to say you what you did wrong.
Regards
Michel
|
|
|
| Re: read only user [message #317064 is a reply to message #317059 ] |
Tue, 29 April 2008 06:43 |
nani_ar
Messages: 42
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 #317066 is a reply to message #317064 ] |
Tue, 29 April 2008 06:59 |
Michel Cadot
Messages: 15225
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| Quote: | as you don't post what you really did, it is impossible to say you what you did wrong.
|
Nothing changed with your new post.
Regards
Michel
|
|
|
| Re: read only user [message #317076 is a reply to message #317056 ] |
Tue, 29 April 2008 07:48 |
nani_ar
Messages: 42
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
|
|
|
| Re: read only user [message #317078 is a reply to message #317076 ] |
Tue, 29 April 2008 08:00 |
Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
| Quote: | When i try to fetch the rows by logging with B,
SQL>select *from B.PAT;
--------I get no rows.
|
Should be "A."; why did you grant SELECT from A to B, if you are querying B's table?
|
|
|
| Re: read only user [message #317085 is a reply to message #317078 ] |
Tue, 29 April 2008 08:06 |
nani_ar
Messages: 42
Registered: March 2006 |
Member |
|
|
Hi,
Sorry..It is Select *From A.PAT
Regards
nani
|
|
|
| Re: read only user [message #317089 is a reply to message #317076 ] |
Tue, 29 April 2008 08:28 |
Michel Cadot
Messages: 15225
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Copy and paste the whole SQL*Plus session and FORMAT it as explained in OraFAQ Forum Guide, "How to format your post?" section.
Regards
Michel
|
|
|
]
Members
Search
Help
Register
Login
Home
