Public Role Permissions concern

• Brandie Tarvin

  SSC Guru

  Points: 173056

  More actions

  September 14, 2023 at 5:52 pm

  #4286545

  All,

  I've been double-checking security for one of my servers and I found the below permissions on the public role. I'm trying to decide if those are default / system-granted permissions that are necessary for the functioning of SQL Server or if these might have been granted by someone some time ago. Does anyone know?

  PermissionType PermissionName DatabaseRole ObjectSchema ObjectName ObjectType

  GRANT EXECUTE public dbo fn_diagramobjects SQL_SCALAR_FUNCTION

  GRANT EXECUTE public dbo sp_alterdiagram SQL_STORED_PROCEDURE

  GRANT EXECUTE public dbo sp_creatediagram SQL_STORED_PROCEDURE

  GRANT EXECUTE public dbo sp_dropdiagram SQL_STORED_PROCEDURE

  GRANT EXECUTE public dbo sp_helpdiagramdefinition SQL_STORED_PROCEDURE

  GRANT EXECUTE public dbo sp_helpdiagrams SQL_STORED_PROCEDURE

  GRANT EXECUTE public dbo sp_renamediagram SQL_STORED_PROCEDURE

   

  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.

• Michael L John

  One Orange Chip

  Points: 27055

  More actions

  September 14, 2023 at 6:21 pm

  #4286549

  When you right click on a database, and double click "Database Diagram", those objects and perms are created.

  You need to be db_owner to create an view a diagram.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/