I have been using Live API creator and I am stuck on a few points which are mentioned below.
Do let me know if you have any suggestions.
Can anyone suggest how to disable a specific stored procedure in CA Live API Creator?
We can Exclude any table or any stored procedure in CA LIVE API Creator by adding the procedure name in
Steps: Click on any LAC project --> On the Left Panel Click on DataSources-->Schema Filters Tab-->Add the procedure name you want to exclude.
Can we fetch limited rows from a table using GET call on its API created by LAC?
You can fetch limited no fo rows depending upon the page size.
Please follow the below link
Pagination - CA Live API Creator - 4.1 - CA Technologies Documentation
How to give access to specific procedure and table to a user and disable all other in a data source for him?
For LAC Project Specific you can create a Team Space
Manage TeamSpaces - CA Live API Creator - 4.1 - CA Technologies Documentation
As per your requirement, I guess you need to create a user inside a lac project in which he/she will be having access to a particular resource, so for that, you need to create a ROLE inside a LAC Project and provide this role with a certain set of access permissions. Then create User and add this Role to that user.
Please find the below Screenshot for the reference
Thanks for such a quick response. The solution you provided really helped me in solving my queries.