I came across a row which has multiple values separated by a colon (:).
SQL considers the values to be one and throws an error" Cannot fine the requested Privilege". Example of the row shown below.
Servername Instancename Databasename Environment userid access
ITSUSMPW01430 ITSUSMPW01430 ALL DEV userid SYSADMIN:SERVERADMIN
Here 2 roles are requested seperated by :
Need some assistance on how can we make SQL consider the values different?