Tables deleted from Management Console still visible in EG (oracle library)

[FabioP]

HI everybody,

I created an oracle library in Management Console. I imported both tables and synonyms from oracle and then decided to delete metatada for tables (and leave only synonyms).

So the tables are not in Management Console but are still visible in EG and I can still use them.

Can you explain to me why, please ?

Thank you

[Chuy]

FabioP,

Read this and you will know all that is needed about your issue.

http://support.sas.com/documentation/onlinedoc/guide/EG43MetaLibraries.pdf

Thanks,

Jesus

[ChrisHemedinger · Accepted solution]

Specifically, the issue you are seeing is that the list of tables is controlled by Metadata ONLY when you allow EG to access the library using the META engine.  If you mark the library as Pre-assigned, then the SAS Workspace assigns the library using the "native" engine (in your case, Oracle).  EG uses will see all of the content in the database that they are permitted to see given their Oracle permissions.

There are downsides to using the META engine, as discussed in the above paper and in other threads, so you'll need to decide whether you want to leverage SAS Metadata to control what users see or else instead (perhaps better) use Oracle permissions to control this.

Chris