Desktop productivity for business analysts and programmers

Can't delete dataset/table in sasapp - sasdata

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Can't delete dataset/table in sasapp - sasdata

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


Accepted Solutions
Solution
‎07-21-2014 08:00 AM
Valued Guide
Posts: 3,206

Re: Can't delete dataset/table in sasapp - sasdata

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)

---->-- ja karman --<-----

View solution in original post


All Replies
Esteemed Advisor
Posts: 6,646

Re: Can't delete dataset/table in sasapp - sasdata

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
SAS Employee
Posts: 10

Re: Can't delete dataset/table in sasapp - sasdata

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

Solution
‎07-21-2014 08:00 AM
Valued Guide
Posts: 3,206

Re: Can't delete dataset/table in sasapp - sasdata

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)

---->-- ja karman --<-----
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 826 views
  • 0 likes
  • 4 in conversation