Is there any way to create ACLs for retrieving the schema of a table ?

[SiddharthR69750]

I was able to create ACLs to access the table data but still was getting User Not Authorized when trying to fetch the schema of the table using .do?SCHEMA 

Is there any way to create an ACL to do that ? I don't want to assign the admin role to the user hence require an ACL

[Dr Atul G- LNG]

Hi @SiddharthR69750 

I think the admin right is one required, as it is more in core system access.

[Ankur Bawiskar]

@SiddharthR69750 

the user has what role since he/she is able to see the sys_db_object?

Since the user is directly doing it via URL I believe you can use UI script and check the browser URL and if logged in user doesn't have the admin role then inform them and redirect to home page

If my response helped please mark it correct and close the thread so that it benefits future readers.

[SiddharthR69750]

I created a custom role and added an ACL for sys_db_object read records. Still, I was unable to get the schema of other tables through this role (although I had access to all records of sys_dictionary and sys_db_object). Only when I switched to admin role I was able to get the schema.

So I believe in the end admin role is necessary for this ?

[Dr Atul G- LNG]

Hi @SiddharthR69750 

As I mentioned earlier, these are core codes and access to this via an Admin role is possible. So the cuisine role will not work here.