Back to OIM Explorer

dbo.QBM_FGIUserAccessLevel

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 488 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL21 lines
1CREATE FUNCTION dbo.QBM_FGIUserAccessLevel(2) RETURNS int3  WITH SCHEMABINDING4AS5BEGIN6  DECLARE @erg int7  SELECT @erg = Max(AccessLevel)8  FROM(9  SELECT10    isnull(IS_SRVROLEMEMBER('sysadmin'), 0) * 9 AS AccessLevel11  UNION all12  SELECT13    isnull(IS_MEMBER('db_owner'), 0) * 7 AS AccessLevel14  UNION all15  SELECT16    isNull(IS_MEMBER('OneIMConfigRoleDB'), 0) * 5 AS AccessLevel17  UNION all18  SELECT19    IsNull(IS_MEMBER('OneIMUserRoleDB'), 0) * 3 AS AccessLevel) AS AccessLevels ende:20  RETURN(@erg)21END
Open raw exported source
SQL ยท Raw5 lines
1  create   function dbo.QBM_FGIUserAccessLevel() returns int with SCHEMABINDING as begin declare @erg int select @erg = Max( AccessLevel ) from 2( select isnull(IS_SRVROLEMEMBER('sysadmin'), 0) * 9 as AccessLevel  union all select isnull(IS_MEMBER('db_owner'), 0) * 7 as AccessLevel  union all select3 isNull(IS_MEMBER('OneIMConfigRoleDB'), 0) * 5 as AccessLevel  union all select IsNull(IS_MEMBER('OneIMUserRoleDB'), 0) * 3 as AccessLevel  ) as AccessLevels4 ende: return(@erg) end 5