|
From: John H. <jh...@im...> - 2012-07-26 13:31:11
|
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 |
