topic Re: How to hide the table in metadata libname in SAS Enterprise Guide

How to hide the table in metadata libname

rakeon3 — Wed, 10 Jan 2024 09:52:12 GMT

Hi,

I use SAS EG 8.2.

I have defined a metadata library pre-assigned by SAS Management Console. This library is connected to an Oracle schema.

In SAS EG, it show a lot of table or view that we want to hide. Is there a way to hide the table that we don't want to show?

Thanks,

Re: How to hide the table in metadata libname

LinusH — Wed, 10 Jan 2024 10:42:10 GMT

Do you have a library defined using the metadata engine?

You could combine the METAOUT=ALL libname option with removing metadata registrations for the tables that you don't want to explore.

Another option is to revoke all rights for the users/User Groups that the tables should be hidden from.

Re: How to hide the table in metadata libname

rakeon3 — Wed, 10 Jan 2024 11:05:54 GMT

Hi,

we use metadata engine, but we dont't use to register the metadata table on server.

The library is Oracle connection and we can't define the permissione in Oracle DBMS.

We just use SAS EG, open the library created, and click directly on the table that it shows.

We want to just see only some table from the library created in SAS EG.

Re: How to hide the table in metadata libname

Patrick — Wed, 10 Jan 2024 12:34:54 GMT

@rakeon3 Define the libname in SAS metadata with metaout=datareg (or meta if that's an option) and only register the tables in metadata that you want to make visible and accessible to users.

I don't have access to an environment to test it right now but what you want to achieve is a libname that uses the meta engine with metaout=datareg as this will then only show the metadata table definitions (which also means you need to keep table metadata in sync with the physical tables should they change - like a new column).

Re: How to hide the table in metadata libname

rakeon3 — Wed, 10 Jan 2024 14:54:55 GMT

Hi,

I defined this libname statment in SAS BASE :

libname tt meta library=c_oracle dbuser= dbpasswd=  METAOUT=DATAREG;

It works, and shows only the register table.

But, how can I create a pre-assigned libname with the META Engine in SAS Managmente Console?

which option should I select?

Re: How to hide the table in metadata libname

LinusH — Wed, 10 Jan 2024 16:43:27 GMT

It was a while since I did this (and I don't have access to a fully fledged 9.4 env), but when you are defining your library as pre-assigned, you can chose "Using metadata engine".

https://documentation.sas.com/doc/en/bicdc/9.4/bidsag/n0dyqm6uiptmx0n10c1wuuiavuqh.htm

https://documentation.sas.com/doc/en/bicdc/9.4/bidsag/p0u8xcdo2ll3kmn1oqfz2s0ybooq.htm

Re: How to hide the table in metadata libname

Sajid01 — Sat, 13 Jan 2024 02:45:37 GMT

Hello @rakeon3
The meta libname engine is used for objects already defined in the metadata server.
From your post it appears you are creating the library tt using meta engine and in turn this is using the library c_oracle that has already been defined in the metadata server.
Therefore you are seeing all the tables registered with the library c_oracle.
While there could be many approaches to resolve this issue, one approach is to approach your SAS Administrator (or whosoever having the necessary authority to create the library ) to create an oracle library say for example c_ora2 and register only those table that you want to be available and displayed.
There after you can create the library with meta libname engine. Thus if the new library is c_ora2 then your connection string would be

libname tt meta library=c_ora2 dbuser= dbpasswd=  METAOUT=DATAREG;

Re: How to hide the table in metadata libname

rakeon3 — Tue, 16 Jan 2024 13:33:24 GMT

Hi,

I wasn't able to create from management console the meta library. I have find the the wizzard to create the pre-assigned library :

But I 'am not able to define l'option library =c_ora2 and METAOUT=DATAREG

Re: How to hide the table in metadata libname

Patrick — Wed, 17 Jan 2024 02:35:12 GMT

Using SMC define the library using the Oracle engine. Once define test the connection.

Then register the tables you want to surface, pre-assign your library and select "By metadata library engine" to surface tables in EG only if and as registered in SAS Metadata.

Re: How to hide the table in metadata libname

Sajid01 — Wed, 17 Jan 2024 01:48:18 GMT

Hello @rakeon3
Perhaps I was not clear enough in my earlier post. You need to create the Oracle library in the metadata using SMC and register only those tables that you want to be displayed.
There is a good article that is just right for the purpose https://support.sas.com/techsup/technote/ts771.pdf. There is another resource that may be helpful http://sasissues.blogspot.com/2015/05/how-to-create-library-for-oracle-in-sas.html.
Creation of library are typically done by SAS Administrators. You can approach them for assistance.
Once this is done, you can use the libname statement as mentioned in the earlier post.
Hopefully this should help.