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
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
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
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.