![]() So you can see this matches the documentation. = 1 OR USER_NAME(principal_id) = IS NULL OR name = IS NULL OR principal_id = BY SET = CONVERT(bit,IS_MEMBER('db_owner')) So it seems that you won't be able to do it with lower roles like db_datareader.īehind the scenes, here is what Management Studio is calling to drive the list: CREATE PROCEDURE sysname = int = NULL At that point the db_owner member can choose to take over ownership of the diagram. If the owner of a diagram has been removed from the database, the diagram will remain in the database until a member of the db_owner role attempts to open it.This is only possible if the previous owner of theĭiagram has been removed from the database. Ownership of diagrams can only be transferred to members of theĭb_owner role.Although any user with access to a database can create a diagram, once the diagram has been created, the only users who can see it are the diagram's creator and any member of the db_owner role.
0 Comments
Leave a Reply. |