|
From: John H. <jh...@im...> - 2012-07-26 13:39:56
|
On Thu, 26 Jul 2012, Savoy, Melinda wrote: > 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. In a lot of cases the database is set up to give everybody Owner access by default. That may be due to unskilled (or lazy) administration, or an application that requires full access to properly operate. > Thanks again. Happy to help. > > -----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 |
