• Chowdary,

    Just a quick recommendation. Find a place to store a copy of what permissions you give what users. It's really hard to maintain column and table level permissions when new people come into the company or old people leave unless you've documented what was granted in the first place.

    The GUI doesn't show the granular stuff below database level. At least, not easily. So save the code off in a DBA only location or write up a word doc on share point, or keep a DBA only database that lists everything. Just remember to track it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.