RE: Enabling FGAC policy in the Schema Browser

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.

From: [email protected] [mailto:[email protected]] On Behalf Of Boneist
Sent: Wednesday, November 09, 2011 4:41 AM
To: [email protected]
Subject: [toad] Enabling FGAC policy in the Schema Browser



Message from: Boneist


Hi,

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?

_______________________________________

Historical Messages


Author: Boneist
Date: Wed Nov 09 02:40:56 PST 2011
Hi,

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?
__
_______________________________________