Enabling FGAC policy in the Schema Browser

Boneist <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <28730413.450631320835286546.JavaMail.SYSTEM@alvqcfw02>
 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&#39;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&#39;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&#39;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&#39;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?
__
_______________________________________
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.