View Access and database role db_ddladmin perceived conflict?

• jasonnance77

  SSC Veteran

  Points: 226

  More actions

  September 16, 2011 at 8:05 am

  #244007

  All:

  I have a database that has 20 views previously created within it. A single user needs access to create and alter views. The user now has db_ddladmin and db_datareader rights. He can create a view with no problems. The problem is that once the object is created, we have to execute a grant statement for the same user to select from the new view he created. The user can access the older views with no problems. Is there any way to modify his security so he can:

  1) Create a new view

  and 2) automatically have select access to the new view without running a grant statement?

  I am looking for possible ways to eliminate the grant.

  Jason

• Satish Nagaraja

  SSCrazy

  Points: 2632

  More actions

  September 19, 2011 at 4:13 am

  #1383217

  Is this user part of the same schema for example default dbo schema ?

  Also what happens if the user uses complate path <database name>.<schema name>.<view name> View name in query ?

  Cheer Satish 🙂