Home » RDBMS Server » Server Administration » Access to user_tables and user_source
Access to user_tables and user_source [message #373274] Mon, 09 April 2001 07:04 Go to next message
Marc Scheuner
Messages: 1
Registered: April 2001
Junior Member
Folks,
What's wrong if I can access the user_tables view no problem, but when I try to do a select * from user_source, it won't find the view?? I need to specify sys.user_source in order to get to it.....
Any ideas??

Report message to a moderator

Re: Access to user_tables and user_source [message #373279 is a reply to message #373274] Mon, 09 April 2001 14:58 Go to previous message
Madhav Kasojjala
Messages: 42
Registered: November 2000
Member
USER_SOURCE might not have a public synonym in sys schema, where as user_tables has it.
madhav

Report message to a moderator

Previous Topic: SQL
Next Topic: string pattern matchin in SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 10:36:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.