Databases

  • Azure Databases – Set New Owner

    The database servers at NSWERS are accessed almost exclusively through Microsoft Entra IDs (both in Azure GCC and in Azure Commercial). To set a new owner, with full control of…

  • Connecting to a GCC Database

    Due to the sensitive nature of the data in the GCC Databases, additional connection requirements must be set. Viewing encrypted data also requires key read access to the GCC Key…

  • GCC Databases

    Uploads Server sqldb-filestatus Contains the list of uploaded files, their status, and related messages and activities sqldb-secureutilities Contains the various data points for the Secure Utilities service API, including: sqldbvalidations…

  • RDB Roles and Permissions

    The Research Database has three custom roles: NSWERS_db_reader This role is the one to give normal NSWERS users SELECT (i.e. Read-Only) access to almost all the the tables in RDB.…

  • Stored Procedures

    Stored Procedures in MS SQL are used rarely and only in special cases. fnFileStatus

Databases

  • No categories

Need Support?

Can’t find the answer you’re looking for? Don’t worry we’re here to help!s

Contact Support