Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I can only see system tables in OracleDB via MS Access link

Status
Not open for further replies.
JohnBOA

JohnBOA

MIS
Jul 15, 2002
12
0
0
US
When I set up a link in MS Access to connect to a Oracle DB table I am not able to see the table I need but I can see all the system tables. What do I need to change to prevent the system tables showing?
 
Sort by date Sort by votes
Hi,
The user you connect as controls what you see..
Does that user have permission to se the tables you want?

[profile]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hipath4k
  • Locked
  • Question
Share link to download Orcale 10 G
Replies
0
Views
55
hipath4k
hipath4k
Livia8
  • Locked
  • Question
Can deleted files/ directories (rm -r) be retrieved again?
Replies
6
Views
122
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
158
carp
carp
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
99
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Insert multiple records 1
Replies
9
Views
213
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top