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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.