Assigning Roles at an Asset Level
I am trying to assign a role, in my case Owner, to multiple tables/columns in a domain at the asset level. In the case where I can apply the Role at the schema level, I assigned the Owner to the domain and allowed the role to inherit to the assets. For this particular use case, there are multiple owners to be assigned to various tables/columns in the Physical Data Dictionary domain and needs to be applied at the asset level where there is no inheritance.
Is there an easy way to do so? It is not scalable to do one by one. I cant see a way to import. The only means I have determined so far is in a view and apply Owner to all rows in view. But, even if I filter and its a view, there are up to 1900 rows to assign one owner and hundreds for the other owners. And this isnt a scalable method either. Ideas?
Tom Friesen
·4 years ago · EditedHi Allison,
My experience is similar to yours in that I find that more often than not, any given schema — or even table! — might have different data owners, depending on the columns it contains.
That said, this may or may not help. 🤷
Once registered by a job server, though, one can actually move the specific tables or even columns to more appropriate domains or even communities without risks to the hierarchy or Catalog refreshing updates. So, instead of having a community and domain structure that reflects the database, we’re starting to have a physical data domains within the organizational structure into which we move columns. This way, the ownership assignments for the columns are appropriately assigned, and at a domain/community level. We do keep an original “unclassified” domain for tables and new or unclaimed columns, and try to stay on top of that.
But if you have multiple owners for columns, and it’s truly one-off, then it becomes more difficult. I’d be interested in other people’s input here too.
Cheers,
Tom
rahulchanne111
·4 years ago · EditedHi @allison.wojcik
At one of my clients assignment, I designed a workflow that had a predefined excel template that the User/Community Manger use to upload on the workflow form. The workflow use to perform the responsibility assignment.
The workflow was designed to handle Add/Remove. The Update action was performed by Remove and Add.
Hope this helps
Rahul