Hi Sandy, i can not rename physically as oracle schema wont allow two tables with same name. correction in last post table names.... USA_cust table - registered into 'US' library then renamed to 'customer_details'   (not USA_customer_details   - its typo error). UK_cust table   - registered into 'UK' library then renamed to 'customer_details'    (not UK_customer_details   - its typo error). Users wants to see the renamed table name(customer_details & customer_details) in SAS EG under "Server > SASApp > Libraries >US & UK libraries" appropriately. Can i do log into SAS EG and navigate to Server > SASApp > Libraries >US & UK - rename tables names? i have already renamed table names in SMC after registered them into UK & USA libraries. ... View more

Hi Chris, thank you for your reply. still not getting exactly. i had rename the tables after registered from Oracle schema in SMC as below. Example - registered below tables: USA_cust table - registered into 'US' library then renamed to USA_customer_details. UK_cust table   - registered into 'UK' library then renamed to UK_customer_details. answer for your hint is - i cannot rename the tables in physical location as both tables exists in same schema, wont allow to be create two tables with same name. Users wants to see the renamed table name(USA_customer_details & UK_customer_details) in SAS EG under "Server > SASApp > Libraries >US & UK libraries" appropriately. ... View more

Hi Linush, yes, i can see physical table names in server tab are the physical tables? i can see metadata table names as renamed table names in Folders tab. oracle Engine applied read/deny permissions on libraries in SMC. i think i need to apply the permission on folder structure rather than on libraries using SMC. please comment. ... View more

Hi Linush, Thank you for your reply... I have renamed in SAS SMC after registered the tables from out source. like there are data tables with same name for two entitis but data is different, hence we have prefix with entity code. Ex: like transport entity tables has prefix 'ttf_sample'  for table names & sales entity tables has 'sls_sample' table name and resisted them into two SAS sales library and transport libraries  then renamed in SAS SMC in both libraries to met the table names in rest of the libraries. ... View more