Skip to content

Query: Qry Report User Permissions

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • DatabaseUsers
  • DatabaseUsers Module Permissions

Columns Selected

  • [DatabaseUsers Module Permissions].[Module Permission]
  • LEVEL
  • Username

Where Clause

(((DatabaseUsers.LEVEL)<>\"disabled\"))

Order By

[DatabaseUsers Module Permissions].[Module Permission], DatabaseUsers.LEVEL, DatabaseUsers.Username

SQL

SELECT [DatabaseUsers Module Permissions].[Module Permission], DatabaseUsers.LEVEL, DatabaseUsers.Username FROM [DatabaseUsers], [DatabaseUsers Module Permissions] WHERE (((DatabaseUsers.LEVEL)<>\"disabled\"))