CODEWITHSUNDEEP
sql-servert-sqlmaster-data-services
Arsen Magomedov
Arsen Magomedov

Reputation: 480

MDS error when renaming attribute

I am trying to rename attribute name from 'BRANCH _CODE' to 'BRANCH_CODE' (get rid of that space) at MDS, and I'm getting the following error:

Cannot alter the view 'viw_SYSTEM_2_34_CHILDATTRIBUTES', because it does not exist or you do not have permission.

The according user is a 'sysadmin' and 'dbowner' of MDS database. Has anyone ever faced this problem?

Upvotes: 0

Views: 919

Answers (1)

Arsen Magomedov
Arsen Magomedov

Reputation: 480

Solved it. It was the SQL security issue. Someone somehow changed the security settings of MDS SQL user "mds_schema_user". I made him the owner of the following schemas of MDS DB:

  • mdm
  • mdq
  • stg
  • dqs
  • db_owner

It worked well for me.

Upvotes: 2

Related Questions