How to generate an SQL database user report via Infor Cloudsuite
With Infor Cloudsuite’s SQL Users And Roles Report Service, there is no need to setup any DBA permissions or to use database management software in order to see who has Database access and with what role.
- Login to Infor Cloudsuite and go to the Service Request tab, then click Create a Service Request
- Select Deployment and Request Type: SQL Users And Roles Report >> Next
- Select the Database Server and Database fields >> Submit
- This report can take anywhere from 5-15 minutes. Once complete, select the Request ID created and download the Users or Roles report for review.
If you found this article helpful and need support managing your Infor Cloudsuite or Lawson Database processes, Nogalis provides expert managed services to simplify and optimize your system. From resolving issues like database user management to maintaining/optimizing existing processes, our team is equipped to deliver the assistance you need—without the cost and commitment of a full-time, in-house staff. Contact us to learn more about how we can help streamline your Lawson environment.
Retiring Lawson, PeopleSoft, or Oracle? APIX archives the entire application — every table, every year, attachments and security included — into your own AWS account in about 30 days, so you can decommission the legacy system and keep full access to the history.
