Home » RDBMS Server » Security » read only user
read only user [message #317056] Tue, 29 April 2008 06:23 Go to next message
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 #317059 is a reply to message #317056] Tue, 29 April 2008 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 Go to previous messageGo to next message
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 #317066 is a reply to message #317064] Tue, 29 April 2008 06:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 Go to previous messageGo to next message
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
Re: read only user [message #317078 is a reply to message #317076] Tue, 29 April 2008 08:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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 Go to previous messageGo to next message
nani_ar
Messages: 58
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Previous Topic: Log in as local user
Next Topic: Login as sysdba in local host
Goto Forum:
  


Current Time: Thu Mar 28 18:30:47 CDT 2024