SQLLawman

Family man and SQL Geek

Developer can not create views

By MichaelDeputy, 1 year and 7 months ago

I received a e-mail a few days ago from one of our developers informing me that he is unable to create views on one of our SQL Server 2005 databases.  He also told me he had another developer try and she also could not create views.  Interesting, I thought, so out to my favorite co-worker - Google.  My buddy Google quickly pointed me to this MSDN post.  This explained to me that when a user gains rights by Active Directory group membership they are not given a default schema.  Say what? Yes, that's right, because multiple AD groups could have rights on a database, and a user could be a member of multiple AD groups it could get confusing.  So any statement that requires a schema will fail with some form of the following error message.

Keep reading →

Related posts

Share this post

Subscription Options:

Subscribe via RSS Subscribe via Email

Search

Tags

Categories

Archives

Links

Latest posts

Latest comments

  • Who’s Winning the Olympics?:
    • MichaelDeputy: That is a very astute observation, but if one athlete were able to win 2 golds and 2 silvers it would give the country a huge boost and obviously that country produced the best athlete (in his/her discipline) which is what I am looking for. After all the song they play is the national...
    • SQLRockstar: how about tracking the distinct number of athletes that win medals? if one country sends ten athletes, but one athlete wins two golds and two silvers, then their score (by your scale) would be a 1.0, which is quite skewed. it would be better to only count that athlete once, not sure which medal...
    • Jenny: Very cool system. I can't wait to see how your scores pan out over the next two weeks.
  • SKU is Invalid when installing 2nd node in SQL 2008:
  • Find all Triggers:
    • SQLRockstar: funny, i just put together some t-sql for finding triggers as well: SELECT name, OBJECT_NAME(parent_id), is_disabled as [Parent Object] FROM sys.triggers i use sys.triggers because it includes DDL triggers, which are not in the sysobjects table.

Most commented posts