db_owner: Unable to view proc properties.

• Jp

  Default port

  Points: 1419

  More actions

  September 25, 2006 at 1:59 pm

  #114589

  Hi,

  I have a Windows Group which is given db_owner access to the database.It's members are not able to view properties of procs in dbo schema.All the procs in the database are owned by dbo.When they try to view the properties by right click/property, the error pop up isefault schema does not exists or don't have enought access rights.

  When they try to view table properties in same database, it works fine.

  any help?

  Thanks,

  Jp

• Jp

  Default port

  Points: 1419

  More actions

  September 25, 2006 at 2:00 pm

  #662359

  Sorry I forget to metion sql version.

  It's sql2005 ,sp1.

  Thanks.