Toad World® Forums

Enabling FGAC policy in the Schema Browser


We have a table that has FGAC enabled for it and in order to access the table, we have to run a stored proc with the necessary parameters etc.

I’ve got my Toad set to run in threads, so when I run the stored proc to enable the access policy in the editor, it doesn’t affect the schema browser.

Is there a way to somehow run the stored proc within the schema browser, so that I can access the data in the table via the Data tab?

You either need to commit from the editor so the SB can see it, or turn of
threaded queries in Toad. We are forced to use a separate session when you use
threaded queries.