Desktop productivity for business analysts and programmers

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

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

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


Accepted Solutions
Solution
‎12-18-2012 02:03 PM
Community Manager
Posts: 2,889

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

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

View solution in original post


All Replies
Occasional Contributor
Posts: 10

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

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

Solution
‎12-18-2012 02:03 PM
Community Manager
Posts: 2,889

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

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 234 views
  • 3 likes
  • 3 in conversation