Creating a user with API rights only to Orion.Events table

To the best of my knowledge the Orion.Events entity is only accessible to accounts with full admin rights.  I'm going to play around a little bit to see if there's some other setting/permission I'm omitting, but I think you might be stuck.

You may want to upvote an existing Feature Request about granular rights on the platform (More granular permissions for users - Feature Requests - The Orion Platform - THWACK (solarwinds.com).

Thank you !

I did upvote the feature request.

I'm still checking on my side also, please let me know if you find any option.

I tried all kinds of different permissions, and I couldn't find a way without granting admin rights to create event entries.

What's your exact use case?  There's a chance the alerting engine could do it for you.

My use case is:

1. Inserting new records on Orion.Events table using POST request to:
   ORION-IP:17778/.../Orion.Events 
2. Reading from Orion.Events table using GET request from:
   ORION-IP:17778/.../Query EventTime,Message FROM Orion.Events where EventType = XXXX or EventType = XXXX ORDER BY EventTime ASC;"
   
3. Reading from Orion.AlertHistory table using GET request from:
   ORION-IP:17778/.../Query TOP 10 TimeStamp, Message FROM Orion.AlertHistory where (AlertObjectID = XXXX or AlertObjectID = XXXX )  order by TimeStamp desc

My use case is:

1. Inserting new records on Orion.Events table using POST request to:
   ORION-IP:17778/.../Orion.Events 
2. Reading from Orion.Events table using GET request from:
   ORION-IP:17778/.../Query EventTime,Message FROM Orion.Events where EventType = XXXX or EventType = XXXX ORDER BY EventTime ASC;"
   
3. Reading from Orion.AlertHistory table using GET request from:
   ORION-IP:17778/.../Query TOP 10 TimeStamp, Message FROM Orion.AlertHistory where (AlertObjectID = XXXX or AlertObjectID = XXXX )  order by TimeStamp desc

Yerah - sorry.  Maybe I was unclear.  What would cause #1 from above?

I have some custom HTMLs with JS scripts interacting with other systems.

For logging purposes, I'm inserting records into Orion.Events table, which will be used later to generate a report using the query in #2.

That's what I was looking for.  Is it a web page or something that can be "read" by the SolarWinds Platform?  If so, they might be able to use the alerting engine to trigger the event.

Example:

1. If the web page contains the word "down."
2. Trigger an alert.
3. Alert Action: Write something to the Event Log.

Otherwise, I'm afraid you'd going to either need to use an admin account or directly edit the SQL table (which is a very bad idea).