Home » RDBMS Server » Server Administration » table access
table access [message #372914] Sat, 17 March 2001 10:30 Go to next message
Hamsa
Messages: 2
Registered: March 2001
Junior Member
I have two users A and B. A has a created a table test and granted permission select on test to B. But B is not able to see that table when he gives select *from table. Please let me know the procedure to access to table test from user B
Thanks in advance

Report message to a moderator

Re: table access [message #372916 is a reply to message #372914] Sat, 17 March 2001 11:15 Go to previous message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hi,

You are correct but your query is wrong,

The user b will execute the following query

select * from a.test;

Report message to a moderator

Previous Topic: table access
Next Topic: Need help in sql query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 11 02:08:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.