Skip to content

Views and View like Functions (M2)

Jump to bottom
Steven Rollo edited this page Jan 5, 2018 · 4 revisions

Functions

  • ClassDB.getUserActivitySummary(UserName)

    • Proposed new function for getting an activity summary for a single supplied user
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor
    • Queries: ClassDB.User
    • Columns:
      • DDLCount, LastDDLObject, LastDDLActivityAt, ConnectionCount, LastConnectionAt from ClassDB.User

  • Public.getMyActivitySummary()

    • Proposed new name for Public.MyActivity(). Queries ClassDB.getUserActivitySummary for the session user only
    • The new names leave room for functions / views that display the entire DDL and connection activity logs for each user
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor, ClassDB_Student
    • Queries: ClassDB.getUserActivitySummary(session_user)
    • Columns: All from ClassDB.getUserActivitySummary(session_user)

  • ClassDB.getUserDDLActivity(UserName)

    • Returns all DDL log entries for the specified user
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor
    • Queries: ClassDB.DDLActivity, ClassDB.User (Maybe?)
    • Columns:
      • StatementStartedAt: StatementStarted from ClassDB.DDLActivity
      • DDLOperation from ClassDB.DDLActivity
      • DDLObject from ClassDB.DDLActivity

  • Public.getMyDDLActivity()

    • Returns all DDL log entries for the current user
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor, ClassDB_Student
    • Queries: ClassDB.getUserDDLActivity(session_user)
    • Columns: All from ClassDB.getUserDDLActivity(session_user)

  • ClassDB.getUserConnectionActivity(UserName)

    • Returns all connection log entries for the specified user
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor
    • Queries: ClassDB.ConnectionActivity, ClassDB.User (Maybe?)
    • Columns:
      • AcceptedAt from ClassDB.ConnectionActivity

  • Public.getMyConnectionActivity()

    • Returns all connection log entries for the current user
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor, ClassDB_Student
    • Queries: ClassDB.getUserConnectionActivity(session_user)
    • Columns: All from ClassDB.getUserConnectionActivity(session_user)

  • ClassDB.getUserActivity(UserName)

    • Returns all DDL and connection log entries for the specified user
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor
    • Queries: ClassDB.DDLActivity, ClassDB.ConnectionActivity, ClassDB.User (Maybe?)
    • Columns:
      • ActivityAt: StatementStarted from ClassDB.DDLActivity union AcceptedAt from ClassDB.ConnectionActivity
      • ActivityType: 'DDL' or 'Connection'
      • DDLOperation from ClassDB.DDLActivity or NULL
      • DDLObject from ClassDB.DDLActivity or NULL

  • Public.getMyActivity()

    • Returns all DLL and connection log entries for the current user
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor, ClassDB_Student
    • Queries: ClassDB.getUserActivity(session_user)
    • Columns: All from ClassDB.getUserActivity(session_user)

Views

  • Public.MyActivitySummary

    • Proposed new name for Public.MyActivity
    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor, ClassDB_Student
    • Queries: Public.getMyActivitySummary
    • Columns: All from Public.getMyActivitySummary()

  • Public.MyDDLActivity

    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor, ClassDB_Student
    • Queries: Public.getMyDDLActivity()
    • Columns: All from Public.getMyDDLActivity()

  • Public.MyConnectionActivity

    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor, ClassDB_Student
    • Queries: Public.getMyConnectionActivity()
    • Columns: All from Public.getMyConnectionActivity()

  • Public.MyActivity

    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor, ClassDB_Student
    • Queries: Public.getMyActivity()
    • Columns: All from Public.getMyActivity()

  • ClassDB.StudentActivityAll

    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor
    • Queries: ClassDB.User
    • Columns:
      • UserName, LastDDLActivityAt, LastDDLOperation, LastDDLObject, DDLCount, LastConnectionAt,ConnectionCount from ClassDB.User

  • ClassDB.StudentActivityAnon

    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor
    • Queries: ClassDB.StudentActivityAll
    • Columns: All from ClassDB.StudentActivityAll except UserName

  • ClassDB.StudentTable

    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor
    • Queries: ClassDB.User, INFORMATION_SCHEMA.Tables
    • Columns:
      • UserName: Table_Schema from INFORMATION_SCHEMA.Tables
      • TableName: Table_Name from INFORMATION_SCHEMA.Tables
      • TableType: Table_Type from INFORMATION_SCHEMA.Tables

  • ClassDB.StudentTableCount

    • Owned by: ClassDB
    • Accessible to: ClassDB_Instructor
    • Queries: ClassDB.User, INFORMATION_SCHEMA.Tables
    • Columns:
      • UserName: Table_Schema from INFORMATION_SCHEMA.Tables
      • TableCount: COUNT(*) of result
Clone this wiki locally