I am not an administrator of our QC.
When I was trying to create Command object to write some SQL queries, encountered an error saying "You don't have permission to create Command Object" was appeared.
Is there any other way to write SQL queries to get data from QC database?
You can use the Excel Reports feature if you are working in QC 9.2 or later.
This is also access driven.
Make sure you have both design/execute permissions for excel reports.
Only Select commands can be executed, since as other update queries is also by default disabled(configuration driven)
-- Here to Learn and share ---