Solved

Database table is not visible. How to make it visible?

Posted on 2009-06-30
5
264 Views
Last Modified: 2012-05-07
I created a database with MS SQL Management Sudio and added a database to it. For now logging in is through the Windows NT authentication. My problem is that I am working on an application and plan and ODBC access to the database and table. I'm able to log on to the database. However the app cannot find the table. I compiled a Microsoft app that lists all tables under that database. Surprisingly, it lists all System Tables, all dbo schemas, and others not even shown in Management Studio. Yet my table is nowhere to be seen, though it is also listed in Management Studio as a dbo schema.

How do I make that visible? It seems to be some restriction in terms of security or similar but I don't know where to look, as I've tried comparing the other accesses (Master, etc) that are there.
0
Comment
Question by:RJV
  • 3
5 Comments
 
LVL 22

Accepted Solution

by:
8080_Diver earned 500 total points
ID: 24750227
It sounds like you may not have any permissions on that table.  
Can you open the database in Management Studio and look at the permissions for the Username you are using to access the data from your app?  If so, be sure to look at the permissions for that specific user.  Does that user have access to the table?  (If it is a Windows User, you may have to check the groups that to see which group it is in and then check the Group's permissions. ;-)
If you do not have at least Read Access, then the table will not appear to exist.
 
0
 

Author Comment

by:RJV
ID: 24750604
Both access though Windows (system logon). As to Groups this computer is not associated to any groups. Having said that, maybe Management Studio is taking that into account. Where would I find the database Groups in Management Studio? I just hunted around and couldn't find it. Any other tips of security checkpoints will certainly help me drill down.
0
 

Author Comment

by:RJV
ID: 24750906
Looking through Management Studio, everything seems to have security related to it, from the logical users and data to the schema. Right now all I do is log on to the OS and then load Management Studio, with SQL starting up as the usual service. As to the app, I set it also to the same security as the OS. Evidently, not good enough though all I want is something simple. Try to change it and I also have to settle to what is built in. So, having said that, might you suggest what I check out exactly, even if to create another table and/or database. I want to simplify however much I can.
0
 
LVL 14

Expert Comment

by:Jagdish Devaku
ID: 24752348
try to give necessary permissions to BUILTIN/Administrators for the database. normally we give sysadmin permissions to this user id.
try to do it check whether the you are able to view the table for windows authentication login.
bye.
0
 

Author Comment

by:RJV
ID: 24762534
The not so unusual amazing thing. When I posted the question here I suspected of a permissions issue, or something done wrong in Management Studio. Of course, it could also be at the ODBC level or even my code. After looking everything over I decided to ask those who know SQL better (not my goal; suffice to suffer with C++, MFC, threads, etc). As it turned out, you also wondered about permissions. Thus I focused more on that area, in as much as that is possible in Management Studio.

Late yesterday, after over scratching my head, I decided to set this checkbox in ODBC:

   Change the default database to:

...and then select the database I had already selected to access. Why hadn't I done that before? It didn't and does not make sense. Let's face it, I had accessed that very same database and even test connected to it. Well, that did the trick! I hope this helps you or anyone else here in the future.

So, while I didn't get a specific solution to my problem, thanks to your pointers I was better able to zero in. So I will award the points in thanks for effort that led to the solution.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
index  - last use and update 8 56
SSIS how to COMPARE a data column from different servers? 6 89
Divide by zero error encountered. 2 33
Strange msg in the SSMS pane 13 49
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now