Re: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box

[Savoy, M. <ms...@wc...>]

Thanks John.  I appreciate the explanation.  I really don't remember  having to do this at my last job where I used SQuirreL.  We just logged in via our Alias and under the database name there were my tables.

Thanks again.

-----Original Message-----
From: John Hardin [mailto:jh...@im...] 
Sent: Thursday, July 26, 2012 8:31 AM
To: Savoy, Melinda
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box

On Wed, 25 Jul 2012, Savoy, Melinda wrote:

> Finally resolved my issue.  Thank you all for all our help.  The issue 
> was that I was not looking under the correct database role membership 
> which is DBO.  There were all the tables I was looking for.  
> Definitely another way to look at tables.  I just thought they would 
> be directly under the database names.  Weird.  Maybe the way SQL 
> Server is setup here?  I'm not sure.  When I used SQuirreL a year ago 
> at my other job before I was laid off I had what I would call a normal view.

The "Database Owner" role has access to all tables in the database. If a given user is not a DBO, then they have to be granted specific access to query/update/delete from individual tables, views, etc. This is the MSSQL fine-grain access control design.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   USMC Rules of Gunfighting #7: In ten years nobody will remember the
   details of caliber, stance, or tactics. They will only remember who
   lived.
-----------------------------------------------------------------------
  10 days until the rover Curiosity lands on Mars