Can't delete dataset/table in sasapp - sasdata

[olivier_guitton]

Hello,

Under SAS Enterprise Guide, i can't delete dataset, i have always this message "User does not have appropriate authorization level for library". The problem, in management console i have checked that i have all rights to delete. The data is saved in sasapp - sasdata.

I can't delete with management console because, the library appears empty. It's strange.

How i can do it ?

Thank you

[Kurt_Bremser]

You do not have write permissions on the directory that is referenced by the libname sasdata. This is most likely because it resides in the home directory tree of the userid used to install SAS. As a "normal" user, you are not supposed to write/delete anything there.

If it is not in the installation user home directory tree, you still need write permissions on the directory wherever it resides.

PS you won't see any tables that are visible in EG in the MC unless those tables have been imported into the metadata. Libraries that are not assigned with libname metadata are checked for physical presence of .sas7bdat files and may show tables that are not visible in MC.

[Unkie_SAS]

This error message is typically as a result of operating system permissions rather than permissions within the Metadata Server.

[jakarman · Accepted solution]

Yep, the mistake is assuming the SAS metadata is the leading service for all security.  This part is only (and partially) to trust when every access to the system  and data is controlled solely by the SAS service.  Trying to overrule the operating system security is not a smart idea. As the Operating system is always in control, do you ignore that data leaks are more troublesome to prevent /detect.  Needing sftp ssh or other host access makes this a idea a fail from start. 

Possible causes:

- Operating system controls blocks access.

- inconsistent positioning of a default location (user home is not set as default but a inaccessible part of sasapp config)

- lockdown settings in the SAS-configuration by you platform admin

- Access is readonly setting on the used libname settings.

- (metadata you have excluded this one)