Posts

Showing posts from November, 2024

SQL - Sav role Features and Web Services

  SELECT   sv . rolename      AS   "Role Name" ,         'Feature'        AS   "Type of Access" ,         fr . featurename   AS   "Feature" ,         fr . description   AS   "Description" FROM     savrole_feature   svf         INNER   JOIN   savroles   sv                 ON   sv . rolekey   =   svf . rolekey         INNER   JOIN   feature   fr                 ON   fr . featureid   =   svf . featureid UNION SELECT   Trim ( Substring_index ( Substring_index ( rm . configattribute , ...