It is surely not the SAS metadata that is leading. Start with your organization. There are 4 kinds of objects 1 users (any type including service and test accounts). 2 groups to organize access being the technical ones allowing tools or some business application or some department. 3 the business applications getting technical organized by groups for code and data with technical accounts 4 the tools like Sas oracle or whatever. The os is irrelevant. A business application can have empty code data storage allowing self service. That is a generic data model. There are two exams by SAS for a metadata security design. One is application driven the other organizational. They should be mixed. For your question for two departments sharing a library, that doesn't make sense. Most likely you are into a business application where data should be read shared. Implement it that way. With self service building could be done at a personal or department way but that approach is not correct. Let them build those in normal dtap approaches. Get no ict involved claiming development by selfservice is not allowed. They should cooperate. May be that is the rootcause you are in.
... View more