| nadeem |
Posted: Jan 15, 2007 02:24:44 AM |
Total Post: 15
Joined: May, 2006
|
Hi all,
I want to grant select permission to user on few tables.But my db new user does not see these tables rows after logging.
What is this issue? and how can i resolve this.
Regards,
Nadeem Ahmed Bhatti
|
|
|
 Jayanta |
| Posted: Jan 15, 2007 01:27:36 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
will u plz explain the prob a little bit elaborately?
with regards
jayanta
|
|
|
|
|
| nadeem |
| Posted: Jan 16, 2007 12:34:45 AM | |
|
Total Post: 15
Joined: May, 2006
|
I created a new user and granted select permission on x1,x2, & x3 tables and new user also have connect permission. I logged in successfully through my new user but, when i tried to see struc / data of these tables using command desc, and select, then my new user was getting to see .
with regards,
nadeem
|
|
|
|
|
| nadeem |
| Posted: Jan 16, 2007 12:42:00 AM | |
|
Total Post: 15
Joined: May, 2006
|
With reference to my previous reply in which i wanted to write that "new user was not getting to see these tables stru. and data"
with regard,
nadeem
|
|
|
|
|
| goldmonkey |
| Posted: Jan 25, 2007 01:34:39 PM | |
|
Total Post: 7
Joined: Jan, 2007
|
No idea what you mean, say like this:
Login in as user A:
grant select on X1 to B;
Login in as user B:
desc X1
will not work;
you need issue:
desc A.X1
if you want desc X1 work for user B, need to do this:
create synonym X1 for A.X1;
then desc X1 will work under user B
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
